Displaying indexes
To display properties for a selected index:
Procedure
- Log into the NonStop SQL/MX Database Manager.
-
In the Navigation tree pane, click
Database.
MXDM displays a list of available systems in My Systems.
- Select a system from My Systems.
-
Expand a selected system in the navigation tree.
List of catalogs for the selected system appears.
-
Select a catalog and then expand
Schemas folder within it.
List of schemas appears.
- Expand a selected schema and select Tables folder.
-
Expand the
Tables folder.
List of tables appears.
-
Select and expand a table within it.
Indexes and Triggers folders appear.
-
In the Index folder, select the required index.
In the right pane, the following tabs related to index appear:
- Columns
- Attributes
- DDL
- Partitions