Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 14-11
Choose an Index
Use the Catalogs and Indexes pane to choose an index to rename.
To choose an index
1. In the Catalogs field, double-click on the name of the catalog that
contains the index. The indexes in the selected catalog are displayed in
the Indexes field.
2. Double-click on the index you want to rename. The attributes of the
selected index are displayed.
Display Dependencies
Before renaming an index, you can analyze the impact of renaming:
• To display the programs that depend on the index, click on
Dependent Programs. Programs that would be invalidated by
renaming the index are displayed.
• To display all objects, including programs, that depend on the
index, click on Objects. All SQL objects that depend on the index
are displayed.
Assign the New Name
Use the Rename pane to change the index name. To rename the index, type
the new name in the Rename field.
Managing Index Comments
You can add, modify, or delete comments for an index. Index comments
consist of one or more lines of text.
To display the Index Comment window, click on Indexes in the Main
window, then click on Index Comments. The Index Comments window is
displayed, as shown in Figure 14-5.