Beyond the Basics: Unpacking Database Indexes
Update: 2025-06-21
Description
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
Comments
In Channel
Download from Google Play
Download from App Store
United States00:00
00:00
x
