Use case

To achieve good performance regardless of the ordering key, if the data is mostly ordered.

Describe the solution you'd like

A table-level setting (MergeTreeSettings) named minmax_index_for_all_numeric_columns. It will enable a minmax index with a granularity of 1 for all columns of numeric type when there is not already an index of the same minmax type for the same expression.

It is likely that we will enable it by default.