Skip to content

Partition Pruning

An optimization technique that reduces cost by processing only relevant partitions in batch jobs and queries.

Partition pruning reduces runtime and cost by preventing irrelevant partitions from being scanned during data processing. It can make a substantial difference, especially in large date-based batch workloads. However, it works well only when partition design is aligned with query and job access patterns. Effective pruning directs computation toward what is truly needed rather than the full data volume.