Displaying materialized view indexes summary – HP Neoview Release 2.4 Software User Manual
Page 43
Displaying Materialized View Indexes Summary
To display a detailed summary of the materialized views:
1.
Select a Schema and right-click on the Materialized View folder and select Show Summary
Details. Clicking on Show Summary Details displays a separate window with a summary
of the materialized views.
The materialized views partition summary displays:
•
Name: The name of the materialized view.
•
Total Current Row Count: The total number of rows in each materialized view.
•
Total Maximum Size: The total maximum size of the materialized view (in bytes).
•
Total Current Size: The total current size of the materialized view (in bytes).
•
Percent Allocated: The percent full of the materialized view.
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%.
Displaying Materialized View Indexes and Their Properties
43