Join Condition 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 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.

Example of a Join Condition Report

The following table describes the Join Condition report.

Join Condition 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).
Join Condition Condition applied to join the table/spool relations.