Skip to main content
These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.

materialize_skip_indexes_on_merge

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

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

When enabled, MATERIALIZE TTL recalculates the stored TTL metadata for each data part without removing expired data during that operation. When disabled, normal TTL materialization usually applies the configured row, column, or GROUP BY TTL actions. For tables with only row TTL and ttl_only_drop_parts enabled, it instead recalculates TTL metadata and drops only fully expired parts.
Last modified on October 4, 2026