Join Order Report

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.

Join Order Report Columns and Descriptions 
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).