Skip to content
Index page splits | The Backend Engineering Show episode artwork

Jan 30, 2022 31 min

Index page splits | The Backend Engineering Show

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

In this episode of the backend engineering show I discuss the ramification of index page splits which results in fragmented index yielding slow query performance when using indexes. I go through what a page is, how a page is read and written in the database and finally discuss the current solutions to address this problem such as reindexing, fill factor and choosing a good index key type. Get my Fundamentals of Database Engineering Udemy course https://database.husseinnasser.com 0:00 Intro 1:50 What is a Page? 5:00 How to Read and Write a page 8:45 Batching Writes and WAL 11:45 The Order of Content in the Page 16:00 Page Splits 21:30 Solving Index Fragmentation 28:30 Summary

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Index page splits | The Backend Engineering Show

0:00 31:54

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 31 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on January 30, 2022.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

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