Dispelling Database Myths: Why Cartesian Joins are your secret SQL tool

Date:May 2, 2024

In the world of SQL, conventional wisdom suggests that Cartesian Products are usually the result of incorrect joins and should be avoided at all costs. But what if you could actually use them to your advantage?

In this short video, our Senior Data Engineer and Architect, Malcolm Green, debunks this common misconception and demonstrates how, in the right scenario, Cartesian Joins (or Cross Joins) can in fact be the correct tool for the job.

This video is part of our series branded ‘Not All SQL is Equal’ (#notallsqlisequal) published by our Data Engineering team. The videos are based upon scenarios they regularly encounter in their day-to-day roles to equip you with tips, tricks, and skills to get the most out of the technology architecture in your business.

About Projective Group

Established in 2006, Projective Group is a leading Financial Services change specialist.

We are recognised within the industry as a complete solutions provider, partnering with clients in Financial Services to provide resolutions that are both holistic and pragmatic.  We have evolved to become a trusted partner for companies that want to thrive and prosper in an ever-changing Financial Services landscape.