Partition Pruning
When a query's predicate constrains the partition key, the planner (or executor, for runtime-known values) skips partitions that cannot contain matches, turning a scan of the whole table into a scan of a few partitions. Pruning fails silently if the predicate wraps the partition key in a function or filters on a different column, so partitioned tables must be queried by their key.
This Concept is waiting for its first lesson!
When a query's predicate constrains the partition key, the planner (or executor, for runtime-known values) skips partitions that cannot contain matches, turning a scan of the whole table into a scan of a few partitions. Pruning fails silently if the predicate wraps the partition key in a function or filters on a different column, so partitioned tables must be queried by their key.
Are you a teacher? Sign in to start contributing.
Sign In