Overview
Explore the critical concept of Index Fill Factor in database performance optimization through this comprehensive video from The Backend Engineering Show. Delve into database storage representation, IO costs, index pages, and the impact of page splits. Learn about indexing UUIDs, the double-edged nature of Fill Factor, and how to avoid bad Fill Factor values. Understand index fragmentation and its effects on database performance. Gain valuable insights to enhance your database engineering skills and make informed decisions for optimal database performance.
Syllabus
Intro
Start of the Show
Database Storage Representation
IO Cost
Index Page
Page Splits Cost
Indexing UUIDs
FillFactor
Bad FillFactor values
Fragmentation In Indexes
Summary
Taught by
Hussein Nasser