The Index Condition report provides information about the predicate conditions applied on the table relations in a step. Only the steps where an index condition is applied are displayed.
Figure 75 is an example of the report.
Figure 75: Example of an Index Condition ReportTable 41 describes the Index Condition report.
Column |
Description |
Step |
The specific step in the compare plan. |
Predicate Kind |
I (Index Condition) |
Index Condition |
Identifies one or more predicates applied on a table in a step. |