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.