Set up docs MCPThese settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.
materialize_skip_indexes_on_merge
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.1 | 1 | New setting |
When enabled, merges build and store skip indices for new parts. Otherwise they can be created/stored by explicit MATERIALIZE INDEX or during INSERTs.
See also exclude_materialize_skip_indexes_on_merge for more fine-grained control.
materialize_statistics_on_merge
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.1 | 1 | New setting |
When enabled, merges will build and store statistics for new parts. Otherwise they can be created/stored by explicit MATERIALIZE STATISTICS or during INSERTs
materialize_ttl_recalculate_only
Type
Bool
Default
0
Only recalculate ttl info when MATERIALIZE TTL