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 by query_plan_join_swap_table, which can be set to auto. In this mode, ClickHouse will try to choose the table with the smallest number of rows. #71577 (Vladimir Cherkasov).