These settings are available in system.settings and are autogenerated from source.
use_statistics
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.1 | 1 | Enable this optimization by default. |
/// preferred over ‘allow_statistics_optimize’ because of consistency with ‘use_primary_key’ and ‘use_skip_indexes’ Allows using statistics to optimize queries
use_statistics_cache
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 1 | Enable statistics cache |
| 25.11 | 0 | New setting |
Use statistics cache in a query to avoid the overhead of loading statistics of every parts
use_statistics_for_part_pruning
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.4 | 1 | New setting to use statistics for part pruning during query execution. |
Use statistics to filter out parts during query execution.
When enabled, pruning in SELECT queries will use column statistics (e.g. MinMax statistics) to eliminate parts that cannot contain matching data before reading any data.
Possible values:
- 0 — Disabled.
- 1 — Enabled.