What is 'Pushdown Optimization'?

Approach: Explain moving logic closer to the data source.

A query optimization technique where processing logic (like filters or aggregations) is moved 'down' to the database level rather than pulling all data into the application for processing.

Follow-up: How does this affect network traffic?

Key concepts: predicate pushdown, io reduction.