Dropping an Index

If you no longer need an index, you can use the Object Browser page to drop the index. See "Drop Indexes That Are No Longer Required".

To test this procedure, follow the procedure in "Creating an Index" to create an index.

To drop an index:

Log in to the Database Home Page. See "Logging in to the Database Home Page".
On the Database Home Page, click the Object Browser icon.
In the Object list, select Indexes, then click the EMPLOYEES_HIREDATE_IDX that you previously created.
Click the Drop button to drop the selected index.
Click the Finish button to complete the action.

Note:

You cannot drop an index that is currently used to enforce a constraint. You must disable or drop the constraint and then, if the index is not dropped as a result of that action, drop the index.