The Indexes Used report provides information about the indexes used in a plan. Only the steps where an index is used are displayed. Figure 74 is an example of the report.
Figure 74: Example of a Indexes Used Report
Table 40 describes the Indexes Used report.
|
Column |
Description |
|
Step |
Specific step in the compare plan. |
|
Left Relation |
Name of the left relation. |
|
Indexes Used |
Index name or index columns used at this step. |
|
Right Relation |
Name of the right relation. |
|
Indexes Used |
Index name or index columns used at this step. |