Online Documentation for SQL Manager for Oracle

Creating/editing index


Use the Index tab of Index Editor to create/edit an index and specify its properties.

 

Name

Specify the name of the index to be created, or view the name of the index being edited. Note that the index name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the index will be created.

 

Index Editor - Editing index definition

 

Table schema / Cluster schema

Use the drop-down list to specify the schema containing the table/cluster on which the index is defined.

 

Table name / Cluster name

Use the drop-down list to identify the table/cluster for which the index is created.

 

Specify partitioning

Use the drop-down list to select the partitioning of the index:

GLOBAL (indicates that the partitioning of the index is user defined and is not equipartitioned with the underlying table)

LOCAL (indicates that the index is partitioned on the same columns, with the same number of partitions and the same partition bounds as the table)

NON-PARTITIONED

 

Options

CheckBox Logging

Specify whether the creation of the index will be logged or not in the redo log file.

 

CheckBox Reverse

Enable this option to store the bytes of the index block in reverse order, excluding the rowid.

 

CheckBox No sort

Select this option to indicate to the database that the rows are already stored in the database in ascending order, so that Oracle does not have to sort the rows when creating the index.

 

CheckBox Invisible

Check this option to set the index invisible for the cost-based optimizer.This option is only supported in Oracle version 11.0 and higher.

 

Index type

This group allows you to specify the index type:

RadioButton Table index

RadioButton Cluster index

 

Uniqueness

This group allows you to specify the uniqueness property for the index:

RadioButton Unique (indicates that the value of the column(s) upon which the index is based must be unique)

RadioButton Non-Unique

 

Key compress

RadioButton No Compress

Disables key compression.

RadioButton Compress ... columns

Enables key compression, which eliminates repeated occurrence of key column values and may substantially reduce storage. Use the spinner control to specify the prefix length (number of prefix columns to compress).

 

The Columns area allows you to specify one or more table columns for the index.

To select a column, you need to move it from the Table Columns list to the Index Columns list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.

 

Use the btnReorderItems_MoveUp btnReorderItems_MoveDown buttons to move the columns up an down within the Index Columns list.

 

Use the btnAddExpression Add expression and btnDeleteExpression Delete expression buttons to add/delete the expression built from columns of table, constants, SQL functions, and user-defined functions.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.