HP Neoview Release 2.5 Software User Manual
Page 83
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