Viewing index statistics – HP NonStop G-Series User Manual

Page 205

Advertising
background image

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

14-13

To change index comments, click on the line you want to modify. The
cursor is placed on the line; edit the index comment as desired.

To delete index comments, click on the line of text you want to delete, then
click on Delete Line.

Save the Index Comment

To save new or modified index comments, or to delete them, click on one
of the following:

Execute. Executes the command immediately.

Show. Displays the SQL commands created by dba/m Database
Manager without executing them.

Queue. Queues the command to be submitted in a batch later.

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.

Advertising