Viewing Indexes

You use the Indexes page of Database Control to view the indexes in your database.

To view indexes:

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, do one of the following:

   • Select Index Name to search for indexes by name.

     Every index has a system-assigned or user-assigned name.

   • Select Table Name to search for indexes that belong to a particular table.

5. In the Schema field, enter the name of a schema. Alternatively, click the flashlight icon adjacent to the Schema field to search for a schema.

6. Do one of the following:

   • If you are searching by index name, then leave the Object Name field blank to search for and display all indexes in the schema. Alternatively, enter an index name or partial index name as a search string.

     If you enter a search string in the Object Name field, then all indexes that have names that start with the search string are displayed. If you precede the search string with an asterisk (*), then all indexes that have the search string anywhere in the index name are displayed.

   • If you are searching by table name, then enter a table name or partial table name in the Object Name field.

     If you enter a partial table name as a search string, then indexes are displayed for all tables that have names that start with the search string. If you precede the search string with an asterisk (*), then indexes are displayed for all tables that have the search string anywhere in the table name.

7. Click Go.

   The indexes in the specified schema are displayed.

8. To view the definition of a particular index, select the index and then click View. Alternatively, double-click the index name.

   The View Index page appears. This page includes basic information about the index, including its status, the table and column or columns on which it is built, the space used by the index, the options used in its definition, and index statistics.