use_statistics
/// preferred over ‘allow_statistics_optimize’ because of consistency with ‘use_primary_key’ and ‘use_skip_indexes’ Allows using statistics to optimize queriesuse_statistics_cache
Use statistics cache in a query to avoid the overhead of loading statistics of every partsuse_statistics_for_min_max_aggregation
Answermin, max and count aggregations from per-part column statistics instead of reading data.
When enabled, a query of the form SELECT min(column), max(column), count() FROM table without GROUP BY and filters
is answered from column statistics (e.g. MinMax statistics, see the auto_statistics_types MergeTree setting)
for the data parts that have them materialized, and only the remaining parts are read.
Possible values:
- 0 — Disabled.
- 1 — Enabled.
use_statistics_for_part_pruning
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.