Use this procedure to view the indexes present in the tables referenced in the active query. To compare current indexes to captured indexes, perform the following steps:
Captured indexes, object definitions, and statistics are not available for plans opened from DBQL.
Load an execution plan before viewing the indexes. For more information, see Loading and Viewing an Execution Plan.
-
From the menu bar, choose or from the toolbar, click
.
The main window is transformed. The left pane displays a hierarchical tree of the objects referenced in the query.
Display Object Information
-
Highlight the index in the database list located in the left pane.
The indexes that existed at the time the execution plan was captured are listed in the right pane under Captured time Indexes. If the table still exists and the indexes were changed, the indexes are listed in the right pane under Current Indexes.The number of captured-time and current indexes is listed in the upper right corner and might be helpful for comparison.
-
From the Index Type list, select the type of indexes to view.
By default, All Indexes is selected.
Index Type Description Hash Ordered (ALL) Display hash ordered covering secondary indexes. ALL represents the syntax element specifying that the NUSI retain the row ID pointers for each logical row of a join index (as opposed to only the compressed physical rows).Join Index Display only join index types. Primary Key Display only primary-key index types. Hash Index Display only hash index types. Value Ordered (ALL) Display the value ordered covering secondary indexes. ALL represents the syntax element specifying that the NUSI retain the row ID pointers for each logical row of a join index (as opposed to only the compressed physical rows).Primary Display only nonpartitioned, primary index types. Partitioned Display only partitioned, primary index types. Secondary Displays only secondary index types. Unique Display only unique-constraint, primary index types. Value Ordered Display only value-ordered secondary indexes.