Indexes

You can perform the following operations on an index by right-clicking the index name in the Connections navigator and selecting an item from the menu:

• Open: Opens the index in the right pane.

• Edit Opens the index for editing in the right pane.

• Drop: Deletes the index.

• Rebuild: Recreates the index or one of its partitions or subpartitions. If the index is unusable, a successful rebuild operation makes the index usable. For a function-based index, rebuilding also enables the index; however, if the function on which the index is based does not exist, the rebuild operation fails.

• Rename: Changes the name of the index.

• Make Unusable: Prevents the index from being used by Oracle in executing queries. An unusable index must be rebuilt, or dropped and re-created, before it can be used again.

• Coalesce: Merges the contents of index blocks, where possible, to free blocks for reuse.

• Compute Statistics: For a function-based index, collects statistics on both the index and its base table using the DBMS_STATS package. Such statistics will enable Oracle Database to correctly decide when to use the index.

• Rebuild Index Partition: Rebuilds a specified index partition.

• Drop Index Partition: Drops (deletes) a specified index partition.