Step Information 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

The Step Information report displays the source relations used and the target relations built in a step along with the operation performed and cost estimates. Cost is displayed in HH:MM:SS.ss format.

Use this report to get information about the operands, operation, target, and estimated cost. The step attribute values display if they are available for any one of the plans. When there are multiple step attributes for a given step, the attributes are split across different rows. Figure 65 is an example of the report.

Figure 65: Sample Step Information Report

Table 31 describes the Step Information report.

Table 31: Step Information 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, Retrieve, Aggregate, or Join Method. For more information, see Table 13 on page 39, Table 18 on page 43, Table 19 on page 43, and Table 20 on page 46.
Target Relation1	The name of the first target relation in a step.
Target Relation2	The name of the second target relation in a step.
Estimated CPU Cost	The estimated CPU cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm).
Estimated IO Cost	The estimated I/O cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm).
Estimated Network Cost	The estimated network cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm).
Estimated Heuristic Cost	The estimated heuristic cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS:mm).
Estimated Cost	The estimated cost of the step in hours, minutes, seconds, and milliseconds (HH:MM:SS.ss).
Attribute Name	Additional information for the step depending on the operation performed. For example: Partition Count for hash join steps Go to for recursive queries Merge Mode for merge delete and merge update steps Kind for sum, sample, or stat steps Merge Type for Multiple Row Merge step Note: This column only appears if step attribute values are defined for at least one of the plans.
Attribute Value	The value of the step attribute type. For example: Partition count Recursive step number UpdateInsert UpdateOnly InsertOnly Note: This column only appears if step attribute values are defined for at least one of the plans.