v.24.7Improvement

Partition Pruning for IN Predicates in PARTITION BY Expressions

Official CH changelog text
Partition pruning for IN predicates when filter expression is a part of PARTITION BY expression. #65335 (Eduard Karacharov).
Added partition pruning support for IN predicates when the filter expression is part of the PARTITION BY expression.

Why it matters

This feature improves query performance by enabling more efficient pruning of partitions during query execution when filtering using IN predicates on partitioning keys, reducing unnecessary data scanning.

How to use it

Use IN predicates in the WHERE clause on expressions that are part of the PARTITION BY clause in your table definition to benefit from automatic partition pruning.

Related resources

PreviousNext