To create an index for a selected schema, in the Navigator tab, select Indexes from the object type drop-down list, click Object submenu, and select Create Object.

To edit an index for a selected schema, right-click a table object in the Navigator tab, and select Edit.

Definition pane

• Schema: Database schema that owns the table associated with the index.

• Table: Name of the table associated with the index.

• Schema: Database in which to create the index.

• Tablespace: Tablespace for the index.

• Name: Name of the index.

• Type: The type of Oracle index.

  • Non-unique means that the index can contain multiple identical values.

  • Unique means that no duplicate values are permitted.

  • Bitmap stores rowids associated with a key value as a bitmap.

• Expression: A column name or column expression. A column expression is an expression built from columns, constants, SQL functions, and user-defined functions. When you specify a column expression, you create a function-based index.

• Available Columns: Columns available in the table.

• Selected Columns: Columns selected for the index. Click Add Selected Columns > to move columns from the Available Columns list.

• Order: ASC for an ascending index (index values sorted in ascending order); DESC for a descending index (index values sorted in descending order).