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
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.