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. Figure 70 is an example of the report.
Figure 70: Example of a Join Condition ReportTable 36 describes the Join Condition report.
Column |
Description |
Step |
The specific step in the compare plan. |
Join Kind |
The kind of join performed. For example, Inner, Left Outer, Right Outer, or Full Outer join. |
Join Type |
The type of join performed by Teradata Database. The join types that can be performed are further described in Table 19 on page 43. |
Join Condition |
The condition applied to join the table/spool relations. |