Operands 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

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

Example of an Operand Report

The following table describes the Operands report.

Operands Report Columns and Descriptions 
Column Description
Step Specific step number in the compare plan.
Left Relation Name of the left relation in a step.
Right Relation Name of the right relation in a step.
Operation Type of operation performed, for example, All AMP Retrieve, Dynamic Hash Join, or Product Join. For more information, see:
Target Relation Indicates the related spool.