Displaying indexes in a schema

To display the schema indexes:

Procedure

  1. In the navigation tree, select a schema.
  2. In the right pane click Indexes tab, or click Indexes folder in the schema.

    The following details appear:

    • Name: The name of the index. Each index name is a hyperlink. Clicking the hyperlink displays the details of the index.

    • On: The table for which the particular index is created.

    • Metadata UID: The internal UID number of the index.

    • Creation Time: The time and date when the index was created. The Creation Time attribute is in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Redefinition Time: The time and date when the index was last redefined. The Redefinition Time attribute is in the yyyy-MM-dd HH:mm:ss.FFFFFF format.