v.20.5Improvement

Improve enable_optimize_predicate_expression=1 Logic for VIEW

Improve enable_optimize_predicate_expression=1 logic for VIEW. #11513 (Artem Zuikov).
Enhanced the logic of enable_optimize_predicate_expression=1 setting for materialized VIEWs to improve predicate optimization.

Why it matters

This improvement refines how predicate expressions are optimized when using materialized VIEWs, resulting in more efficient query execution and better performance by enabling more effective predicate pushdown and filtering.

How to use it

Enable the optimization by setting enable_optimize_predicate_expression=1 in the server or session settings. This will automatically apply improved predicate optimization logic for materialized VIEW queries.