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

Sample Step Information Report

The following table describes the Step Information report.

Step Information 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, Retrieve, Aggregate, or Join Method.

For more information, see Retrieval-Method Icons, Aggregate-Step Icons, Join-Method Icons, and Other Operation Icons.

Target Relation1 Name of the first target relation in a step.
Target Relation2 Name of the second target relation in a step.
Estimated CPU Cost Estimated CPU cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm).
Estimated IO Cost Estimated I/O cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm).
Estimated Network Cost Estimated network cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm).
Estimated Heuristic Cost Estimated heuristic cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS:mm).
Estimated Cost Estimated cost of the step in hours, minutes, seconds, milliseconds (HH:MM:SS.ss).
Attribute Name Additional information for the step depending on the operation performed; such as the following:
  • 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
This column only appears if step attribute values are defined for at least one of the plans.
Attribute Value Value of the step attribute type; such as the following:
  • Partition count
  • Recursive step number
  • UpdateInsert
  • UpdateOnly
  • InsertOnly
This column only appears if step attribute values are defined for at least one of the plans.