What is 'Predicate Pushdown'?

What is 'Predicate Pushdown'?

Approach: Explain filtering data at the source.

A query optimization that moves the 'WHERE' clause filtering as close to the data source as possible, reducing the amount of data transferred and processed.

Follow-up: Is this possible with Parquet files?

Key concepts: where clause, io optimization.