beautypg.com

Viewing index statistics – HP NonStop G-Series User Manual

Page 205

background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004

14-13

Viewing Index Statistics

Using the Index Statistics window, you can display the statistics of an
index.

To display the Index Statistics window, click on Indexes in the Main
window, then click on ViewStats. The Index Statistics window is
displayed, as shown in Figure 14-6.

Figure 14-6. Index Statistics Window.

To display indexes

1. In the Catalogs field, double-click on the catalog that contains the

indexes. The indexes in the catalog are displayed in the Indexes field.

2. Use one of the following methods to display index statistics:

To display statistics for one or more indexes, double-click on the
name of each index

To display statistics for all indexes in the catalog, click on
SelectAllIndexes.

Statistics for the selected indexes are automatically displayed in
the Index Statistics pane.

3. To exit from Index Statistics window, click Close.