Skip to content
Index Fill Factor | The Backend Engineering Show episode artwork

Jul 11, 2022 34 min

Index Fill Factor | The Backend Engineering Show

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Index Fill Factor | The Backend Engineering Show

0:00 34:36

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 34 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on July 11, 2022.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.