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.
The following table describes the Operation report.
|Step||Specific step number in the compare plan.|
|Operation||Type of operation performed, for example, Retrieve, Aggregate, or Join Method. For more information, see:|