What is 'Query Pruning' in data warehouses?

Approach: Describe skipping files based on metadata.

The ability of the engine to skip entire files or partitions by checking metadata (like min/max values) without actually opening or reading the data files.

Follow-up: How does sorting data improve pruning?

Key concepts: micro-partitions, metadata filtering.