Syntaxer | SQL Request and Transaction Processing | Teradata Vantage - 17.10 - Syntaxer - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Request and Transaction Processing

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
English (United States)

The Syntaxer checks the request parcel for high-level syntax. If no errors are detected, the Syntaxer converts the request parcels into a skeletal parse tree referred to as the SynTree or Black Tree. When this process completes, the Parser passes the SynTree to the DPL component (see Dynamically Parameterized Requests), and then to the Resolver.

A parse tree is a data structure used by the SQL Parser to represent a request parcel in a form that is simple to annotate with various descriptive and statistical information derived from the Data Dictionary and from derived statistics.

The parse tree also permits a relatively simple transformation of the request parcel by Query Rewrite and the Optimizer into an execution plan.