HP NonStop G-Series User Manual

Page 198

Advertising
background image

Managing Indexes

14-6

Figure 14-2. Alter Index Window.

Choose an Index

To choose an index to alter

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
Catalogs and Indexes pane.

2. In the Indexes field, double-click on the index you want to alter. The

attributes of the index are displayed in the File Attributes pane.

Display Dependencies

Before altering an index, you can analyze the impact that the changes will
have:

To display the programs that depend on the index, click on
Dependent Programs. Programs which would be invalidated by
altering the index are displayed.

To display all objects, including programs, that depend on the
index, click on Dependent Objects. All SQL objects that depend on
the index are displayed.

Advertising