Access Planning for Column-Partitioned Objects | Optimizer Process | Vantage - 17.10 - Access Planning for Column-Partitioned Objects - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

Access planning for column partitions is driven by the single-table predicates and the projection list on a column-partitioned database object. The Optimizer groups the single-table predicates and the projection list for a table or join index by the column partitions that contain the referenced columns.

This process includes creating a list of conditions that can be evaluated on the same column partition or set of column partitions.

When there are both single-table predicates and projection columns, predicate ordering takes precedence over projection analysis because evaluating predicates eliminates rows that would project the required columns. When there are insufficient available column partition contexts for both, the Optimizer employs various heuristics to determine whether to apply the predicates and merge the projection columns into a column partition merge spool or only to apply the predicates and output row IDs of the qualified rows to the column partition merge spool.