Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

enable_join_* session settings

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

enable_join_fixed_hash_table_conversion

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.41New setting to enable converting the hash table to a flat array for joins when the key is a single integer with a small value range.

Enable converting the hash table to a flat array for joins when the key is a single integer with a small value range.

enable_join_runtime_filters

Beta feature
Type
Bool
Default
1
Version history
VersionDefault valueComment
26.21Enabled this optimization
25.100New setting

Filter left side by set of JOIN keys collected from the right side at runtime.

enable_join_runtime_filters_index_analysis

Experimental feature
Type
Bool
Default
0
Version history
VersionDefault valueComment
26.70New setting to enable join filtering using dynamic index analysis

Run a second pass index analysis (via use_skip_indexes_on_data_read) to prune granules on LHS of a join.

enable_join_transitive_predicates

Beta feature
Type
Bool
Default
1
Version history
VersionDefault valueComment
26.61Turn on enable_join_transitive_predicates by default
26.40New setting to infer transitive equi-join predicates for join order optimization.

Infer transitive equi-join predicates from existing join conditions. For example, given A.x = B.x and B.x = C.x, a synthetic A.x = C.x predicate is added so the join order optimizer can consider direct (A JOIN C) plans.

Navigation