Hp Neoview Release 2.4 Software Manuale Utente Scaricare il pdf (Pagina 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

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 69 70

Nessun commento

Hp Neoview Release 2.4 Software Manuale Utente Pagina 37