What is an index? | What is a Database? (Pt. 16)

Description

"Create an index" is the most often repeated phrase heard across every database design meeting. At least that's what I've seen. So what gives? Is it true? How do indexes work and why does everyone shout this battle cry when queries aren't performant? ======== 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?