beautypg.com

HP NonStop G-Series User Manual

Page 204

background image

Managing Indexes

14-12

Choose an Index

Use the Catalog and Index pane to choose an index.

To choose the index

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

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

2. Double-click on the name of the index. If there is a comment associated

with the index, the comment text is displayed in the Comment Text
pane.

Add, Change, or Delete Index Comments

To add index comments

1. Click on Add Line. The cursor is placed on the next available line in the

Comment Text pane.

2. Enter the comment.

3. Repeat steps 1 and 2 to add additional lines.

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.