🗄️Partition Pruning
Also known as Partition Elimination
Skipping the table parts a query cannot need. Less is read, so it is faster.
Think of it like
It is like skipping the pages of a book you know you do not need.
Example
A query filters on one day of a table split by day. BigQuery reads 2 GB instead of 700 GB, and the bill drops to match.
Why it matters
This is where splitting a table pays off. If you pay for each scan, the bill shrinks too.
Definition
Example code
sql
SELECT COUNT(*)
FROM events
WHERE date = '2026-11-16';Common mistake
Key takeaways
- 1Read the filter. The engine checks the WHERE clause.
- 2Skip whole parts. Non-matching parts are never opened.
- 3Filter the split column. Pruning needs that exact column.