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_key_only_hash_tables
Use hash tables that store the join keys alone, without a reference to a right row, for joins whose result can never contain a value taken from a right row:LEFT ANTI, and LEFT SEMI when no right column is selected. Such a table has a smaller cell and lets the right blocks be dropped instead of stored.
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
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
Infer transitive equi-join predicates from existing join conditions. For example, givenA.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.