What is a cartesian product? | What is a Database? (Pt. 14)
2025-09-22
Description
You probably haven't heard of "cartesian" since you last took algebra. But "cartesian products" are more vital to the performance of your queries than you realize. Check out this video to understand real fast what they are, and better yet, how to speed them up! ======== Want to take CockroachDB for a spin? Then check out https://university.cockroachlabs.com/ and get started! ======== Don't miss the podcast! 🎧 https://creators.spotify.com/pod/profile/select-star-show/ - Find the SELECT STAR show on YOUR favorite podcasting platform! Greg L. Turnquist worked on the Spring team for over thirteen years before he joined Cockroach Labs as a technical content engineer. He was the lead developer for Spring Data JPA, Spring Web Services, and a committer to multiple Spring portfolio projects. He wrote Packt's best-selling title, Learning Spring Boot 2.0 2nd Edition, and its 3rd Edition follow-up along with many others including 12 Rules for Pro Coders. He co-founded the Nashville Java User Group in 2010 and hasn't met a query (yet) that he can't speed up. About Cockroach Labs: Cockroach Labs is a pioneering software company at the forefront of database technology, dedicated to delivering resilient and scalable database solutions to run mission-critical workloads for the world's most important businesses. With a mission to scale when others fail, Cockroach Labs is revolutionizing the way businesses manage their data with its innovative cloud native distributed SQL database, CockroachDB. WHAT IS A DATABASE? is a book written by Greg L. Turnquist and published by Mountain Summit Press, LLC © 2024 (ISBN 978-1956410433). Permission is granted to Cockroach Labs in perpetuity to create this derivative work, a video series What Is A Database?