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)
[ Ссылка ]

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
[ Ссылка ]

Introduction to NGINX (link redirects to udemy with coupon)
[ Ссылка ]

Python on the Backend (link redirects to udemy with coupon)
[ Ссылка ]

Become a Member on YouTube
[ Ссылка ]

Arabic Software Engineering Channel
[ Ссылка ]

🔥 Members Only Content
[ Ссылка ]



🏭 Backend Engineering Videos in Order
[ Ссылка ]

💾 Database Engineering Videos
[ Ссылка ]

🎙️Listen to the Backend Engineering Podcast
[ Ссылка ]

Gears and tools used on the Channel (affiliates)

🖼️ Slides and Thumbnail Design
Canva
[ Ссылка ]


Stay Awesome,
Hussein

свернуть