HP Database Manager (HPDM) User Guide (R2.4)

Displaying Materialized Views and Their Properties
To display the materialized view 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. 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.
HPDM displays the materialized views in this schema.
In the right pane, these tabs appear:
• Attributes tab
• Partitions tab
• Usage tab
• DDL tab
• Privileges tab
Attributes Tab
To display the materialized view attributes:
1. Navigate to the 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 on the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
Displaying Materialized Views and Their Properties 37