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.
Example of a Join Order Report
The following table describes the Join Order report.
|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).|