3.4.2 The Index Properties Dialog
The Index Properties dialog box is displayed when you create or edit an index.
To create an index for a selected schema, in SQL, 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).
DDL pane
You can review and save the SQL statements that are generated when creating or editing 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.