The Join Condition report provides information about the conditions on which the table or spool relations are joined. Only the steps where a join is performed are displayed.
Example of a Join Condition Report
The following table describes the Join Condition report.
Column | Description |
---|---|
Step | Specific step in the compare plan. |
Join Kind | Kind of join performed. For example, Inner, Left Outer, Right Outer, or Full Outer join. |
Join Type | Type of join performed by Teradata Database (see Join-Method Icons). |
Join Condition | Condition applied to join the table/spool relations. |