v.20.4Improvement

Avoid Excessive Dictionary Load in System Tables

Official CH changelog text
Avoid superfluous dictionaries load (system.tables, DROP/SHOW CREATE TABLE) #10164 (Azat Khuzhin)
Avoid unnecessary loading of dictionaries when querying system.tables or executing DROP and SHOW CREATE TABLE commands.

Why it matters

This feature optimizes performance by preventing superfluous dictionary loading during metadata queries and table manipulation commands, reducing overhead and improving response times for these operations.

How to use it

This improvement is applied automatically in ClickHouse. Users benefit from the optimization without requiring any configuration changes.

Related resources

PreviousNext