These settings are available in system.settings and are autogenerated from source.
enable_join_fixed_hash_table_conversion
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.4 | 1 | New 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 featureType
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 1 | Enabled this optimization |
| 25.10 | 0 | New setting |
Filter left side by set of JOIN keys collected from the right side at runtime.
enable_join_runtime_filters_index_analysis
Experimental featureType
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.7 | 0 | New 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 featureType
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.6 | 1 | Turn on enable_join_transitive_predicates by default |
| 26.4 | 0 | New 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.