Dropping an index – HP Integrity NonStop H-Series User Manual
Page 210

Managing Indexes
14-8
Partitions
The name of partitions for the altered index is displayed in the Partitions
pane.
Choose Index Format
Choose Format of a index by clicking either Format1 or Format2 in
File Format Pane.
Save the Index
To save the modified index attributes, 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.
Dropping an Index
Use the Drop Index window to delete an index. Before dropping an index,
you can analyze the impact of dropping it by displaying a list of SQL
objects that depend on the index.
To display the Drop Index window, click on Indexes in the Main window,
then click on Drop. The Drop Index window is displayed, as shown in
Figure 14-3.