v.20.5Improvement
Improve enable_optimize_predicate_expression=1 Logic for VIEW
Improve enable_optimize_predicate_expression=1 logic for VIEW. #11513 (Artem Zuikov).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 settingenable_optimize_predicate_expression=1 in the server or session settings. This will automatically apply improved predicate optimization logic for materialized VIEW queries.