Skip to content
ClickHouse Docs

use_statistics_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

use_statistics

/// 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

Use statistics cache in a query to avoid the overhead of loading statistics of every parts

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.