HP Neoview Release 2.4 Software - Manual (Page 62)

• 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).
Partitions Tab
To display the materialized view partitions:
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 Partitions tab in the right pane.
In the right pane, these attributes are displayed:
•
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 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 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 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.
62 Manage Database Objects