Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 14-9
Figure 14-3. Drop Index Window.
Choose an Index
Use the Catalogs and Index pane to choose the index for deletion. To
choose an index to drop
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. In the Indexes field, double-click on the name of the index you want to
drop. The attributes of the index are displayed.
Display Dependencies
Before dropping an index, you can analyze the impact of dropping it:
• To display the programs that depend on the index, click on
Dependent Programs. Programs that would be invalidated by
dropping 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.