Creating an Index

Previous

Next

You can create an index with the Object Browser page. To create an index, you specify one or more columns to be indexed and the type of index you want to create.

In the following example, an index is created on the hire_date column of the employees table. When the hire_date column is used as a condition for retrieving data, an index on that column increases the speed of those queries.

To create an index:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the Database Home Page, click the Object Browser icon.

3. In the Detail pane, select Index from the Create menu.

4. In the Table Name field, enter employees.

5. Set the Type of Index to Normal, then click the Next button. See "Index Types".

6. In the Index Name field, enter EMPLOYEES_HIREDATE_IDX.

7. Do not check the Preserve Case box.

8. Ensure that Uniqueness is set to Non Unique. The hire_date column can have duplicate values.

9. In the Index Column 1 list, select HIRE_DATE, then click the Next button.

10. Click the SQL button to view the SQL statement that creates the index.

11. Click the Finish button to complete the action.