Operation 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
previous
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.

Figure 67 is an example of the report.

Figure 67: Sample Operation Report

Table 33 describes the Operation report.

 

Table 33: Operation Report Columns and Descriptions 

Column

Description

Step

The specific step number in the compare plan.

Operation

The type of operation performed. For example, Retrieve, Aggregate, or Join Method.

For more information, see:

  • Retrieval Method Icons in Table 13 on page 39
  • Aggregate Step Icons in Table 18 on page 43
  • Join Method Icons in Table 19 on page 43
  • Other Operation Icons in Table 20 on page 46