Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Index Fill Factor - The Backend Engineering Show

Hussein Nasser via YouTube

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

Reviews

Start your review of Index Fill Factor - The Backend Engineering Show

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.