Physical Database Design

7.6 Partition Elimination 135

partitioning can provide the needed release to gain this efficiency and still avoid the

addressability constraints.

7.6 Partition Elimination

The major performance advantage of range partitioning comes through a technique

known through most of the industry as “partition elimination.” Partition elimination

occurs during SQL compilation time when the query compiler searches for the optimal

query execution plan for a query. The presence of range partitioning based on columns

used in query predicates provides the query optimizer a much clearer view on which

ranges are likely to be accessed as part of the query. This allows the compiler to select a

query execution plan that limits the execution to the ranges that are relevant, ...