Oracle Cloud Infrastructure Documentation

Creating an Index

Note

This feature is not available for MySQL database services.
You can create or edit an index in SQL Worksheet.

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).