Operation Report
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 68 is an example of the report.
Figure 68: Sample Operation ReportTable 33 describes the Operation report.
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: |