Displaying an Index for a Table

Previous

Next

You can use Object Browser to display information about an index on a specific table.

To display information for 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 Object list, select Tables, then click the employees tables.

4. Click Indexes to display the indexes for the table.

5. In the Index list, click the EMP_NAME_IX index to display details for that index. After viewing the object details for the index, click the SQL tab to display the SQL statement used to create the index.

6. Click other indexes in the Object list to display information about those indexes.