Viewing Indexes

Viewing Indexes
You use SQL Developer to view the indexes in your database.
To view indexes:
1. In the Connections navigator, navigate to the Indexes node for the schema that
includes the index you want to view.
If the index is in your own schema, navigate to the Indexes node in your schema.
If the index you want to view is in another user's schema, navigate to the Other
Users node, expand it, find the name of the schema the index is in, and navigate to
the Indexes node.
Examples of schema names include SYS and HR.
2. Open the Indexes node.
The names of the indexes in the selected schema appear below the Indexes node.
3. Click the name of the index you want to view.
A tab with the index name appears in the object pane, with the Columns subtab
displayed. You can view the index definition on this tab.
... zobacz całą notatkę