Search

Home > The Backend Engineering Show with Hussein Nasser > Index Fill Factor | The Backend Engineering Show
Podcast: The Backend Engineering Show with Hussein Nasser
Episode:

Index Fill Factor | The Backend Engineering Show

Category: Technology
Duration: 00:34:36
Publish Date: 2022-07-11 13:07:38
Description: In this episode of the backend engineering show I’ll discuss Fill Factor index property, an important key parameter for a good performing database. I will also discuss how it is a double edge sword and can break or Make your db. Chapters 0:00 Intro 1:48 Start of the Show 4:30 Database Storage Representation 6:30 IO Cost 10:00 Index Page 13:30 Page Splits Cost 18:00 Indexing UUIDs 19:45 FillFactor 23:15 Bad FillFactor values 26:40 Fragmentation In Indexes 30:30 Summary Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon) https://network.husseinnasser.com Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) https://database.husseinnasser.com --- Support this podcast: https://anchor.fm/hnasr/support
Total Play: 0