Example: Deleting an Index

If you no longer need an index, then you can delete it using Database Control.

In this example, you delete the PRODUCTS_SUPPLIER_IDX index that you created previously on the SH.PRODUCTS table in "Example: Creating an Index".

To delete the supplier index on the SH.PRODUCTS table:

1. Go to the Database Home page, logging in as user SYSTEM.

   See "Accessing the Database Home Page".

2. At the top of the page, click Schema to view the Schema subpage.

3. In the Database Objects section, click Indexes.

   The Indexes page appears.

4. In the Search By list, select Table Name.

5. In the Schema field, enter SH.

6. In the Object Name field, enter PROD.

   You can enter only the first few letters of the table name.

7. Click Go.

   All indexes on the PRODUCTS table are displayed.

8. Select the PRODUCTS_SUPPLIER_IDX index, and then click Delete.

   A confirmation page appears.

9. Click Yes to delete the index.

   The Indexes page returns and displays a confirmation message.