These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.
add_minmax_index_for_block_number_column
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.5 | 0 | New setting. |
When enabled, an implicit min-max (skipping) index is added for the persistent virtual column _block_number.
Requires enable_block_number_column = 1 to take effect. The index is built only during merges,
not during inserts: at insert time the block number is provisional and would index a constant.
add_minmax_index_for_block_offset_column
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.5 | 0 | New setting. |
When enabled, an implicit min-max (skipping) index is added for the persistent virtual column _block_offset.
Requires enable_block_offset_column = 1 to take effect. The index is built only during merges,
not during inserts.
add_minmax_index_for_numeric_columns
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.1 | 0 | New setting |
When enabled, min-max (skipping) indices are added for all numeric columns of the table.
add_minmax_index_for_string_columns
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.1 | 0 | New setting |
When enabled, min-max (skipping) indices are added for all string columns of the table.
add_minmax_index_for_temporal_columns
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 0 | New setting |
When enabled, min-max (skipping) indices are added for all Date, Date32, Time, Time64, DateTime and DateTime64 columns of the table