use_query_cache
If turned on,SELECT queries may utilize the query cache. Parameters enable_reads_from_query_cache
and enable_writes_to_query_cache control in more detail how the cache is used.
Possible values:
- 0 - Disabled
- 1 - Enabled
use_query_condition_cache
Enable the query condition cache. The cache stores ranges of granules in data parts which do not satisfy the condition in theWHERE clause,
and reuse this information as an ephemeral index for subsequent queries.
Possible values:
- 0 - Disabled
- 1 - Enabled
use_query_condition_cache_for_top_k
Enable the query condition cache for queries that use theORDER BY <column> LIMIT n (TopK) optimization (dynamic filtering or skip-index based). When disabled, such reads neither consult nor populate the cache.
Such queries can drop granules during execution depending on the running threshold, so their cache entries are partitioned by the TopK plan parameters and by the set of parts read. This setting is disabled by default while the soundness of these cache entries is being established; it has no effect unless use_query_condition_cache is also enabled.
Possible values:
- 0 - Disabled
- 1 - Enabled