HP Neoview Release 2.4 Software - Manual (Page 41)

Displaying Materialized View Indexes and Their Properties
To display the materialized view index information:
1. Start the HP Database Manager and log on using any user ID.
2. Click the Database area.
3. Select a system in My Active Systems in the navigation tree.
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 on 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.”
Displaying Materialized View Indexes and Their Properties 41