Operands Report - Visual Explain

Teradata Visual Explain User Guide

Product

Visual Explain

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2504

lifecycle

Product Category

Teradata Tools and Utilities

Each step is composed of one or more operands and a target. The Operand report provides information about the operands for each step. These are also referred to as source relations.

Figure 68 is an example of the report.

Figure 68: Example of an Operand Report

Table 34 describes the Operand report.

Table 34: Operand Report Columns and Descriptions
Column	Description
Step	The specific step number in the compare plan.
Left Relation	The name of the left relation in a step.
Right Relation	The name of the right relation in a step.
Operation	The type of operation performed. For example, All AMP Retrieve, Dynamic Hash Join, or Product Join. For more information, see: Retrieval Method Icons in Table 13 on page 39 Aggregate Step Icons in Table 18 on page 43 Join Method Icons in Table 19 on page 43 Other Operation Icons in Table 20 on page 46
Target Relation	Indicates the related spool.