https://community.databricks.com/t5/data-engineering/why-do-my-queries-involving-cartesian-product-run-slowly/m-p/18363#M12172 <P>Cartesian product is the worst type of join that you should always avoid, it tends to product N x M where N &amp; M are the left and right table cardinality. unless you specifically want to use it, then you should avoid and opt for faster joins (inner, left, right) etc..</P> Mon, 28 Jun 2021 18:13:06 GMT amr 2021-06-28T18:13:06Z https://community.databricks.com/t5/data-engineering/why-do-my-queries-involving-cartesian-product-run-slowly/m-p/18362#M12171 Fri, 25 Jun 2021 22:33:28 GMT https://community.databricks.com/t5/data-engineering/why-do-my-queries-involving-cartesian-product-run-slowly/m-p/18362#M12171 brickster_2018 2021-06-25T22:33:28Z https://community.databricks.com/t5/data-engineering/why-do-my-queries-involving-cartesian-product-run-slowly/m-p/18363#M12172 <P>Cartesian product is the worst type of join that you should always avoid, it tends to product N x M where N &amp; M are the left and right table cardinality. unless you specifically want to use it, then you should avoid and opt for faster joins (inner, left, right) etc..</P> Mon, 28 Jun 2021 18:13:06 GMT https://community.databricks.com/t5/data-engineering/why-do-my-queries-involving-cartesian-product-run-slowly/m-p/18363#M12172 amr 2021-06-28T18:13:06Z