Operation 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 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: