Database Page Splits - The Backend Engineering Show

Explore the intricacies of database page splits and their impact on query performance in this informative video from The Backend Engineering Show. Delve into the concept of database pages, understanding their structure and how they are read and written. Learn about batching writes and Write-Ahead Logging (WAL) techniques. Discover the significance of content order within pages and the phenomenon of page splits. Investigate solutions to address index fragmentation, including reindexing, fill factor adjustments, and selecting optimal index key types. Gain valuable insights into improving database efficiency and query performance through this comprehensive exploration of database page management.

Intro
What is a Page?
How to Read and Write a page
Batching Writes and WAL
The Order of Content in the Page
Page Splits
Solving Index Fragmentation
Summary