beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 83

background image

The detailed summary is a snapshot of the materialized view in the schema at the timestamp
shown at the top of the table display. If you select [ Refresh ] the summary is refreshed. A row
is highlighted in red if the partition is equal to or greater than 80%.

Display Materialized View Groups and Their Properties

When you create a materialized view, a materialized view group is created automatically. It has
the same name as the table that the materialized view references.

To display the materialized view group 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 Systems in the navigation tree.

4.

Select a Schema in the navigation tree.

5.

Click the Materialized View Groups tab in the right pane, or open the MV Groups folder
and select a materialized view group name in the tree.

In the right pane, these tabs appear:

Attributes tab

Members tab

DDL tab

Display Materialized View Groups and Their Properties

83