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.
| 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). |