v.23.7Improvement
Add optimize_use_implicit_projections Setting to Disable Implicit Projections
Add settingoptimize_use_implicit_projectionsto disable implicit projections (currently onlymin_max_countprojection). #52152 (Amos Bird).
Why it matters
This feature provides users with control over implicit projections, which are optimizations applied automatically. Disabling implicit projections can help address issues related to projection usage or optimize query performance in specific scenarios by turning off currently only themin_max_count projection.How to use it
To disable implicit projections, set theoptimize_use_implicit_projections setting to 0 in your query or configuration. For example:SET optimize_use_implicit_projections = 0;This will disable the use of implicit projections such as
min_max_count during query execution.