v.24.4Performance Improvement
Convert OUTER JOIN to INNER JOIN for Default Value Filtering Optimization
Convert OUTER JOIN to INNER JOIN optimization if the filter after JOIN always filters default values. Optimization can be controlled with setting query_plan_convert_outer_join_to_inner_join, enabled by default. #62907 (Maksim Kita).