v.25.9Experimental Feature

Support alter table

Official CH changelog text
Support alter table ... materialize statistics all will materialize all the statistics of a table. #87197 (Han Fei).
Added support for ALTER TABLE ... MATERIALIZE STATISTICS ALL to materialize all statistics of a table in ClickHouse.

Why it matters

This feature enables users to efficiently compute and materialize all the table statistics at once, improving query optimization and performance by ensuring all relevant statistics are up-to-date.

How to use it

Use the ALTER TABLE your_table_name MATERIALIZE STATISTICS ALL command to materialize all statistics for the specified table.

Related resources

PreviousNext