v.23.7Improvement

Add optimize_use_implicit_projections Setting to Disable Implicit Projections

Add setting optimize_use_implicit_projections to disable implicit projections (currently only min_max_count projection). #52152 (Amos Bird).
Added the setting optimize_use_implicit_projections to allow disabling implicit projections in ClickHouse, currently affecting only the min_max_count projection.

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 the min_max_count projection.

How to use it

To disable implicit projections, set the optimize_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.