User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 14-5
Save the Index
To save 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.
Altering an Index
Using the Alter Index window, you can change an index’s security or file
attributes, or add, change, or delete partitions in the index. You can also
analyze the impact of the changes on other SQL objects before you save
the changes.
To display the Alter Index window, click on Indexes in the main window,
then click on Alter. The Alter Index window is displayed, as shown in
Figure 14-2.
Figure 14-2. Alter Index Window.