v.19.3Experimental Features

Added Conversion of CROSS JOIN to INNER JOIN If Possible

Added conversion of CROSS JOIN to INNER JOIN if possible. #4221 #4266 (Artem Zuikov)
Added automatic conversion of CROSS JOIN to INNER JOIN when conditions allow.

Why it matters

This feature optimizes query execution by converting CROSS 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 with CROSS JOIN. The query planner will convert the join to INNER JOIN if the conversion criteria are met, requiring no additional user action.