Use this procedure to view the indexes present in the tables referenced in the active query.
Note: 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” on page 145.
1 From the menu bar, choose View > Current vs. Captured > Indexes or from the toolbar, click .
The main window is transformed. The left pane displays a hierarchical tree of the objects referenced in the query.
Figure 52: Display Object Information2 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.
Note: The number of captured‑time and current indexes is listed in the upper right corner and might be helpful for comparison.
3 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. Note: 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. Note: 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. |