Column Partition Elimination | Optimizer Process | Teradata Vantage - 17.10 - Column Partition Elimination - 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)

Column-partitioned tables are subject to column partition elimination during query processing. Column partition elimination enhances query performance by allowing the Optimizer to ignore column partitions that are not referenced by a query.

Search conditions applied to the remaining partitions can reduce how much of those partitions must be scanned, further enhancing performance.

If multiple columns are required for the response set for a query, the query plan includes putting projected column values from selected table rows together to form result rows. Vantage can combine this with row partition elimination to further reduce the data that must be accessed to satisfy a query.