OPTIMIZE Statement
ClickHouse
Statements
https://clickhouse.com/docs/sql-reference/statements/optimize
Introduction
Merge Multiple Parts into Fewer or Single Parts
Merges multiple data parts (files) into one, reducing fragmentation and improving query performance.
Only affects parts within the sam...