HP Neoview Release 2.4 Software - Manual (Page 39)

Partition Number: The index number of the partition. •
•
Percent Allocated: The percentage full of the partition.
• Row Count: The current total number of rows in the partition.
• 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 on 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 on 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 materialized view was created. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the materialized view 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 on 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 on 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 SQL Reference Manual.
For more information about displaying DDL, see “Displaying Schema DDL and Their Properties”
(page 53) .
Privileges Tab
To display the privileges for the materialized view:
1. Select a Schema in the navigation tree.
2. Click on 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 on the Privileges tab in the right pane.
The Privileges tab displays a table showing the access privileges.
• Grantee: The name of a user whose privilege is being described.
• Grantor: The name of the user who granted the privileges and the special SQL user names
“PUBLIC” and “SYSTEM.”
Displaying Materialized Views and Their Properties 39