v.19.3Experimental Features
Added Conversion of CROSS JOIN to INNER JOIN If Possible
Added conversion ofCROSS JOINtoINNER JOINif possible. #4221 #4266 (Artem Zuikov)
Why it matters
This feature optimizes query execution by convertingCROSS JOIN to INNER JOIN whenever the join conditions make it possible. This improves performance and resource utilization by avoiding unnecessary Cartesian products.How to use it
Users benefit from this feature automatically when writing queries withCROSS JOIN. The query planner will convert the join to INNER JOIN if the conversion criteria are met, requiring no additional user action.