HP Neoview Release 2.5 Software - Manual (Page 82)

Name: Name of the materialized view index. •
•
Unique: Specifies if the materialized view index is unique, the value is “Yes” or “No.”
• Populated: Specifies if the materialized view index has been populated, the value is
“Yes” or “No.”
• Creation Time: Time and date when the materialized view index 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 index was last redefined.
Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
DDL Tab
To display DDL output for the materialized view:
1. Select a Schema in the navigation tree.
2. Open the Materialized Views folder, select and open a Materialized View.
3. Open the Indexes folder and select a materialized view index in the tree.
4. Click the DDL tab in the right pane.
The DDL tab displays DDL output from the SHOWDDL 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) .
Partitions Tab
To display partition information for a materialized view index:
1. Select a Schema in the navigation tree
2. Open the Materialized Views folder, select and open a Materialized View.
3. Open the Indexes folder and select a materialized view index in the tree.
4. 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.
Materialized View Indexes Summary
To display a detailed summary of the materialized view indexes:
1. Expand the Schema folder so that you can see the Materialized Views folder.
2. Expand the Materialized Views folder to display the materialized views within the folder.
3. Expand a materialized view so that you can see the Indexes folder.
4. Right-click the Indexes folder, and select Show Summary Details.
The materialized views partition summary displays:
• Name: The name of the materialized view.
• Total Current Row Count: The total number of rows in each materialized view.
• Total Maximum Size: The total maximum size of the materialized view (in bytes).
• Total Current Size: The total current size of the materialized view (in bytes).
• Percent Allocated: The percent full of the materialized view.
82 Display Database Objects