Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

use_statistics_* session settings

These settings are available in system.settings and are autogenerated from source.

use_statistics

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.11Enable 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
VersionDefault valueComment
26.21Enable statistics cache
25.110New 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
VersionDefault valueComment
26.41New 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.
Navigation