Displaying materialized views and their properties, Attributes tab – HP Neoview Release 2.4 Software User Manual
Page 37

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