beautypg.com

Displaying materialized view indexes summary – HP Neoview Release 2.4 Software User Manual

Page 43

background image

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