Join Condition Report - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Join Condition Report

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. Figure 71 is an example of the report.

Figure 71: Example of a Join Condition Report

Table 36 describes the Join Condition report.

 

Table 36: Join Condition Report Columns and Descriptions 

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 join types that can be performed are further described in Table 19 on page 45.

Join Condition

The condition applied to join the table/spool relations.