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