v.18.12Improvement

Conditions Cast into View with Predicate Expression Optimization Enabled

Official CH changelog text
Conditions are cast into the View (when enable_optimize_predicate_expression is enabled). Winter Zhang
Improves query optimization by casting conditions into Views when enable_optimize_predicate_expression is enabled.

Why it matters

This feature enhances the predicate pushdown optimization by allowing conditions to be cast directly into Views, improving query execution efficiency and reducing unnecessary data processing.

How to use it

Enable the optimization by setting the server or session setting enable_optimize_predicate_expression to 1 (true). Once enabled, condition casting into Views will be applied automatically during query execution.

Related resources

PreviousNext