Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

add_minmax_* MergeTree table settings

These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.

add_minmax_index_for_block_number_column

Type
Bool
Default
0
Version history
VersionDefault valueComment
26.50New 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

Type
Bool
Default
0
Version history
VersionDefault valueComment
26.50New 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

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.10New setting

When enabled, min-max (skipping) indices are added for all numeric columns of the table.

add_minmax_index_for_string_columns

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.10New setting

When enabled, min-max (skipping) indices are added for all string columns of the table.

add_minmax_index_for_temporal_columns

Type
Bool
Default
0
Version history
VersionDefault valueComment
26.20New setting

When enabled, min-max (skipping) indices are added for all Date, Date32, Time, Time64, DateTime and DateTime64 columns of the table

Navigation