Displaying indexes

To display properties for a selected index:

Procedure

  1. Log into the NonStop SQL/MX Database Manager.
  2. In the Navigation tree pane, click Database.

    MXDM displays a list of available systems in My Systems.

  3. Select a system from My Systems.
  4. Expand a selected system in the navigation tree.

    List of catalogs for the selected system appears.

  5. Select a catalog and then expand Schemas folder within it.

    List of schemas appears.

  6. Expand a selected schema and select Tables folder.
  7. Expand the Tables folder.

    List of tables appears.

  8. Select and expand a table within it.

    Indexes and Triggers folders appear.

  9. In the Index folder, select the required index.
    In the right pane, the following tabs related to index appear:
    • Columns
    • Attributes
    • DDL
    • Partitions
    Table index properties