v.25.10New Feature
Add an ability to automatically create statistics
Added an ability to automatically create statistics on all suitable columns inMergeTreetables. Added table-level settingauto_statistics_typeswhich stores comma-separated types of statistics to create (e.g.auto_statistics_types = 'minmax, uniq, countmin'). #87241 (Anton Popov).
Why it matters
This feature automates the generation of column-level statistics such as minmax, uniq, and countmin, improving query optimization and performance by providing the optimizer with more detailed data insights without manual effort from users.How to use it
Enable automatic statistics creation by setting theauto_statistics_types table setting with a comma-separated list of desired statistics types, for example: auto_statistics_types = 'minmax, uniq, countmin'.