Dropping an index – HP NonStop G-Series User Manual

Page 200

Advertising
background image

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.

Advertising