v.25.7Performance Improvement
Optimize the generated plan
Optimize the generated plan for correlated subqueries by removing redundant JOIN operations using equivalence classes. If there are equivalent expressions for all correlated columns,CROSS JOINis not produced ifquery_plan_correlated_subqueries_use_substitutionsetting is enabled. #82435 (Dmitry Novik).