Viewing Indexes

You use SQL Developer to view the indexes in your database.

To view indexes:

  1. In the Connections navigator in SQL Developer, 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.

    Note:

    You must have the necessary privileges to view other schemas and the objects in those schemas.

  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.

See Also:

"About Indexes"