The Residual Condition report provides information about the predicate conditions applied on the table relations in a step. Only the steps where a residual condition is applied are displayed.
Example of a Residual Condition Report
The following table describes the Residual Condition report.
Residual Condition Report Columns and Descriptions
Column |
Description |
Step
|
Specific step in the compare plan. |
Predicate Kind
|
Predicate kind:
- Additional join condition (A).
- Range constraint (G). Used for value-ordered relations.
- Join condition (J).
- Condition on a left relation in a join (L).
- Partition elimination (Q). Occurs for a source condition. A residual condition on the left or right table in a join or on a single-table retrieval. Partition elimination occurs prior to accessing the rows, so the condition applies only to rows retrieved from partitions that were not eliminated.
- Condition on a right relation in a join (R).
- Source condition (S). A residual condition on the left or right table in a join or on a single-table retrieval. No partition elimination occurs prior to accessing the rows.
|
Residual Condition
|
List of each predicate applied on a table in a step. A letter represents each predicate type:
- A (additional join)
- G (range constraint)
- J (join condition)
- L (condition on a left relation in a join)
- Q (partition elimination)
- R (condition on a right relation in a join)
- S (source condition)
|