Partition Pruning

Indexing

An optimization where the query planner eliminates partitions that cannot contain rows matching the query's WHERE clause. Reduces the amount of data scanned in partitioned tables.

Related terms