v.25.9Performance Improvement
Implemented rewriting of JOIN: 1
Implemented rewriting of JOIN: 1. ConvertLEFT ANY JOINandRIGHT ANY JOINtoSEMI/ANTIJOIN if the filter condition is always false for matched or non-matched rows. This optimization is controlled by a new settingquery_plan_convert_any_join_to_semi_or_anti_join. 2. ConvertFULL ALL JOINtoLEFT ALLorRIGHT ALLJOIN if the filter condition is always false for non-matched rows from one side. #86028 (Dmitry Novik).