1. Using Oracle® SQL Developer Web
  2. Creating and Editing Database Objects
  3. The Index Properties Dialog

8.2 The Index Properties Dialog

The Index Properties dialog box is displayed when you create or edit an index. You can create and edit in three ways:

  • In Worksheet, in the Navigator pane, select Indexes in the object field, click Create icon , and select Create Object.

  • In Worksheet, right-click a table in the Navigator tab, and select Add Index. To edit, right-click an index in the Navigator tab and select Edit.

  • Right-click a table object in the Data Modeler Navigator tab, and select Add Index.

  • Create and edit an index in the Table Properties Dialog (See The Table Properties Dialog).

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 the Add Selected Columns icon 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).

DDL pane

You can review and save the SQL statements that SQL Developer Web will use to create or edit the index. If you want to make any changes, go back to the Definition pane and make the changes there. For a new index, click CREATE to view the generated DDL statements. When you edit index properties, click UPDATE to view the generated ALTER statements. For a new index, the UPDATE tab will not be available. When you are finished, click Apply.

Output pane

Displays the results of the DDL commands. If there are any errors, go to the Definition pane, fix the errors, and run the commands again. You can save to a text file or clear the output.