beautypg.com

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

Page 37

background image

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