When the user submits a query in a Teradata database, it follows a path from the origin to the data, as shown in the following figure:
Any query submitted to the Teradata system from a Teradata client, such as BTEQ or SQLA, goes through CLIv2 or ODBC to the Parsing Engine (PE), which parses the query to ensure syntax and generates an execution plan for the query. The execution steps are then passed on by the PE to AMPs over the Bynet; AMPs perform their operations and return the result set over the Bynet, back to PE, and PE delivers the result set to the Teradata client tool that submitted ...