v.24.6Experimental Feature

Support Statistics with ReplicatedMergeTree

Support statistics with ReplicatedMergeTree. #64934 (Han Fei).
Adds support for collecting and maintaining statistics on tables using the ReplicatedMergeTree engine in ClickHouse.

Why it matters

This feature enables users to gather and utilize table statistics on replicated MergeTree tables, which improves query optimization and performance by providing the query planner with better data distribution and cardinality information for replicated tables.

How to use it

Statistics are supported automatically for tables created with the ReplicatedMergeTree family of engines. Users can utilize existing SQL commands to show, analyze, and refresh statistics on these replicated tables without additional configuration.