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 valueordered 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 singletable 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 singletable 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)
