Learn AI, Data Science & Business — Earn Certificates That Get You Hired
AI Engineer - Learn how to integrate AI into software applications
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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