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.
Example of an Index Condition Report
The following table describes the Index Condition report.
| Column | Description |
|---|---|
| Step | 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. |