Hp Neoview Release 2.4 Software Instrukcja Użytkownika Pobierz pdf (Strona 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

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 69 70

Brak uwag

Hp Neoview Release 2.4 Software Instrukcja Użytkownika Strona 43