enable_join_* session settings

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

enable_join_fixed_hash_table_conversion

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

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

enable_join_runtime_filters_index_analysis

Prune granules on the probe side of a JOIN with the runtime filter collected from the build side, see enable_join_runtime_filters. Only has an effect if use_skip_indexes_on_data_read = 1. Only a join key that is a primary key column of the probe side, or is covered by a minmax, set or bloom_filter skip index, can be pruned. If the runtime filter kept the exact key values, the pruning predicate is an IN set of them, otherwise the minimum/maximum key range is used (this has a lower pruning power).

enable_join_transitive_predicates

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.