Skip to content
Beyond the Basics: Unpacking Database Indexes episode artwork

Jun 21, 2025 29 min

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Beyond the Basics: Unpacking Database Indexes

0:00 29:01

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Joy of Architecture?

This episode is 29 minutes long.

When was this Joy of Architecture episode published?

This episode was published on June 21, 2025.

Can I download this Joy of Architecture episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.