User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 14-9
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.
Drop the Index
To drop the index, 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.
Renaming an Index
Use the Rename Index window to rename an index. You can also analyze
the impact of changing the index’s name by displaying all objects that
depend on the index.
To display the Rename Index window, click on Indexes in the Main
window, then click on Rename. The Rename Index window appears, as
shown in Figure 14-4.