Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
use_skip_indexes

Use data skipping indexes during query execution. Possible values:
  • 0 — Disabled.
  • 1 — Enabled.

​
use_skip_indexes_for_disjunctions

Evaluate WHERE filters with mixed AND and OR conditions using skip indexes. Example: WHERE A = 5 AND (B = 5 OR C = 5). If disabled, skip indexes are still used to evaluate WHERE conditions but they must only contain AND-ed clauses. Possible values:
  • 0 — Disabled.
  • 1 — Enabled.

​
use_skip_indexes_for_top_k

Enable using data skipping indexes for TopK filtering. When enabled, if a minmax skip index exists on the column in ORDER BY <column> LIMIT n query, optimizer will attempt to use the minmax index to skip granules that are not relevant for the final result . This can reduce query latency. Possible values:
  • 0 — Disabled.
  • 1 — Enabled.

​
use_skip_indexes_if_final

Controls whether skipping indexes are used when executing a query with the FINAL modifier. Skip indexes may exclude rows (granules) containing the latest data, which could lead to incorrect results from a query with the FINAL modifier. When this setting is enabled, skipping indexes are applied even with the FINAL modifier, potentially improving performance but with the risk of missing recent updates. This setting should be enabled in sync with the setting use_skip_indexes_if_final_exact_mode (default is enabled). Possible values:
  • 0 — Disabled.
  • 1 — Enabled.

​
use_skip_indexes_if_final_exact_mode

Controls whether granules returned by a skipping index are expanded in newer parts to return correct results when executing a query with the FINAL modifier. Using skip indexes may exclude rows (granules) containing the latest data which could lead to incorrect results. This setting can ensure that correct results are returned by scanning newer parts that have overlap with the ranges returned by the skip index. This setting should be disabled only if approximate results based on looking up the skip index are okay for an application. Possible values:
  • 0 — Disabled.
  • 1 — Enabled.

​
use_skip_indexes_on_data_read

Enable using data skipping indexes during data reading. When enabled, skip indexes are evaluated dynamically at the time each data granule is being read, rather than being analyzed in advance before query execution begins. This can reduce query startup latency. Possible values:
  • 0 — Disabled.
  • 1 — Enabled.
Last modified on July 23, 2026