HP Neoview Release 2.4 Software - Manual (Page 64)

4. Select a Schema in the navigation tree.
5. Open the Materialized Views folder, select and open a Materialized View.
6. Open the Indexes folder and select a materialized view index in the tree.
In the right pane, these tabs appear:
• Columns tab (user only)
• Attributes tab
• DDL tab
• Partitions tab
Columns Tab
To display the materialized view index columns:
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 Columns tab in the right pane.
In the right pane these attributes are displayed:
•
Column Name: Name of the column (string).
• Sort Order: Specifies the order as “Ascending” or “Descending.”
• Added By: Indicates if column was added by the “System” or “User.”
Attributes Tab
To display the materialized view attributes:
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 Attributes tab in the right pane.
In the right pane, these attributes are displayed:
•
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.
64 Manage Database Objects