Beyond the Basics: Unpacking Database Indexes
from Joy of Architecture Hosted by The Architect Guy
This episode dives deep into the fascinating world of database indexes, explaining how they work under the hood. We unpack the internal mechanics, trade-offs, and practical use cases of a dozen different index types—from the ubiquitous B-Trees and Hash Indexes to specialized ones like R-Trees for spatial data and the cutting-edge Learned Indexes. Tune in to understand when and why to choose a particular index, and how they behave in various systems, whether it's a high-throughput OLTP database or a massive analytical data warehouse
Embed this episode
No transcript yet.