Updated on 2025-05-29 GMT+08:00

Dynamic Partition Pruning

If the search condition of a partitioned table query statement contains variables, the optimizer cannot obtain the bound parameters entered by users. Therefore, the optimizer can parse only the search conditions of operators such as index scan, bitmap index scan, and index-only scan. In the executor phase, partition filtering is complete only after the bound parameters are obtained.

The search conditions must contain at least one partition key. For a partitioned table with a multi-column partition key, the search conditions can contain any column of the partition key.

Currently, dynamic partition pruning supports only the parse-bind-execute (PBE) and parameterized path scenarios.