Indexes Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Indexes Editor lets you manage columns, basic properties, storage, space, and partitioning for an index.

To edit an index

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays a listing of the columns making up the index. Optionally, you can:

Use the Sort column check box to specify a sort option.

Click the New button to add a new column to the index.

Select an existing column and click the Delete button to delete that column from the index.


Lets you work with settings in the following categories:


Lets you view IsValid and Function-Based properties. Lets you set Index Type (UNIQUE, NONUNIQUE, BITMAP), No Sort, Logging, Reverse, and Invisible properties.

Parallel Query Option

Lets you view the No Parallel Execution property. Lets you set the Parallel Degree and Parallel Instances values.


Lets you work with settings in the following categories:

Data Block Storage

Lets you choose the Tablespace, and specify Percent Free, Initial Transactions, and Max Transactions values.


Lets you specify Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.


Lets you specify Freelists and Freelist Groups values.

Buffer Pool

Lets you specify a buffer pool.


Lets you view settings in the following categories:

Space Utilization

Lets you view the Size and number of Blocks settings.


Lets you view Index Level, Distinct Keys, Cluster Factor, Leaf Blocks, Leaf Blks/Key and Data Blks/Key properties.


If the index is not currently partitioned, you can click the Convert To Partitioned button to partition the index. For more information, see Partitioning Oracle indexes, primary keys, and unique keys. If the index is currently partitioned, this tab displays the following partition details:


Lets you view the Locality (Global/Local), Alignment (Prefixed/Non-Prefixed), Partition Type (RANGE or HASH), and Subpartition type properties.

Click the Edit Partition button to edit partition details. or more information, see Partitioning Oracle indexes, primary keys, and unique keys.

Click the Drop Partition button to revert to an unpartitioned index.

Use the Partition Commands menu items to initiate object actions. For details, see the following topics: Allocate Extent Analyze Coalesce Deallocate Unused Space Mark Unusable - opens a dialog that lets you select one or more partitions/subpartitions to be marked as unusable. Rebuild - opens a dialog that lets you select one or more unusable subpartitions to be rebuilt. Split - opens a dialog that lets you divide a single partition into two partitions. You can split partitions if a single partition is causing maintenance problems because it is too large. NOTES: If you are preparing to drop or rebuild an index, mark local indexes as unusable. If you want to make unusable indexes valid or to recover space and improve performance, rebuild the unusable indexes. You cannot split a local index partition defined on a hash or composite table. Make sure that you specify an upper bound for the column that is lower than the upper bound for that column in the original partition.


Displays partitioning columns.

Partition Definitions

Displays the list of partition definitions. For each partition definition, listing shows the partition definition Value, the associated Tablespace, and whether the index is Usable or has been marked as Unusable by Oracle. Use the Partition Commands menu Mark Unusable or Rebuild commands to change the current Usable value.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.