Operation Report - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities

The Operation report provides information about the operations performed while executing a query. Depending on the SQL statement, statistics available on the tables in the query and different operations (such as Join, Mergeupdate, and Aggregate step) are performed by Teradata Database. Refer to the query optimization section of SQL Request and Transaction Processing (B035-1142) for more information.

Sample Operation Report

The following table describes the Operation report.

Operation Report Columns and Descriptions 
Column Description
Step Specific step number in the compare plan.
Operation Type of operation performed, for example, Retrieve, Aggregate, or Join Method. For more information, see: