16.10 - Other Query Rewrites - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

Not all query rewrites are performed by the Query Rewrite subsystem. Some, such as the Partial GROUP BY optimization (see Partial GROUP BY Block Optimization), are performed as late in the optimization process as join planning.

The topics that follow briefly describe some of the rewrites and the parse tree transformations that are done by the Optimizer after the Query Rewrite subsystem has completed its tasks.