13 min listen
Index page splits | The Backend Engineering Show
Index page splits | The Backend Engineering Show
ratings:
Length:
32 minutes
Released:
Jan 30, 2022
Format:
Podcast episode
Description
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
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
Released:
Jan 30, 2022
Format:
Podcast episode
Titles in the series (100)
Episode 11 - Persistence by The Backend Engineering Show with Hussein Nasser