Pushdown Across Formats

Concepts: paPredicatePushdown

What They Want to Hear 'Pushdown behavior depends on the storage format. Parquet supports column pruning and row-group statistics filtering natively. Delta Lake adds data skipping with file-level min/max statistics and Z-ordering for multi-column predicates. Iceberg goes further with partition-level statistics and hidden partitioning that decouples the physical partition scheme from the query predicate. Dynamic partition pruning optimizes joins: when one side of a join filters partitions, the engine pushes that filter to the other side at runtime.' This is the answer that shows you understand pushdown is not a single feature but a stack of optimizations that varies by format.