v.24.12Performance Improvement
JOIN Reordering: Selectable Inner Table in Query Plan
JOIN reordering. Added an option to select the side of the join that will act as the inner (build) table in the query plan. This is controlled byquery_plan_join_swap_table, which can be set toauto. In this mode, ClickHouse will try to choose the table with the smallest number of rows. #71577 (Vladimir Cherkasov).