The Join Order report provides information about the order in which the joins are performed in a plan. Only the steps where a join is performed are displayed. Figure 71 is an example of the report.
Figure 71: Example of a Join Order Report
Table 37 describes the Join Order 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 different join types that can be performed are further described in Table 19 on page 43. |