HP Neoview Release 2.5 Software - Manual (Page 79)

• Max Size: The maximum size in bytes of the partition.
• Current EOF: The current data size of the partition in bytes.
Usage Tab
To display materialized view usage information:
1. Select a Schema in the navigation tree
2. Click the Materialized Views tab in the right pane and select a materialized view name, or
open the Materialized Views folder and select a materialized view name in the tree.
3. Click the Usage tab in the right pane. The Usage tab displays the usage relationships of the
materialized view with other objects, if any.
In the right pane, these attributes are displayed:
•
Relationship: Specifies the materialized views relationship with the object specified.
The values are: “Uses,” “Used By,” and “Has.”
• Related Object Type: Specifies the object type of the related object. The values are:
“Table,” “Materialized View,” “View,” or “Synonym.”
• Related Object Name: Specifies the 2-part ANSI object name with a hyperlink to the
object.
• Creation Time: Time and date when the related object was created. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the related object was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
DDL Tab
To display the DDL output for the materialized view:
1. Select a Schema in the navigation tree.
2. Click the Materialized Views tab in the right pane and select a materialized view name, or
open the Materialized Views folder and select a materialized view name in the tree.
3. Click the DDL tab in the right pane.
The DDL tab displays DDL output from the SHOWDDL SQL command in the right pane.
You can highlight and copy contents, but you cannot edit the contents. For more information
about the format of the SHOWDDL command, see the Neoview SQL Reference Manual.
For more information about displaying DDL, see “Display Schema DDL and Their Properties”
(page 91) .
Privileges Tab
To display the privileges for the materialized view:
1. Select a Schema in the navigation tree.
2. Click the Materialized Views tab in the right pane and select a materialized view name, or
open the Materialized Views folder and select a materialized view name in the tree.
3. Click the Privileges tab in the right pane.
The Privileges tab displays a table showing the access privileges.
• Grantee: The name of a role whose privilege is being described.
• Grantor: The name of the role that granted the privileges and the special SQL user names
“PUBLIC” and “SYSTEM.”
• With Grant: Specifies an ‘X’ to indicate if the role has grant privileges.
• Grant Level: The level at which the permissions are visible. The values displayed in this
column are: Schema, Object, or Column.
Display Materialized Views and Their Properties 79