In this episode of the backend engineering show I discuss the ramification of index page splits which results in fragmented index yielding slow query performance when using indexes. I go through what a page is, how a page is read and written in the database and finally discuss the current solutions to address this problem such as reindexing, fill factor and choosing a good index key type.
Get my Fundamentals of Database Engineering Udemy course [ Ссылка ]
0:00 Intro
1:50 What is a Page?
5:00 How to Read and Write a page
8:45 Batching Writes and WAL
11:45 The Order of Content in the Page
16:00 Page Splits
21:30 Solving Index Fragmentation
28:30 Summary
Become a Member on YouTube
[ Ссылка ]
🔥 Members Only Content
[ Ссылка ]
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)
[ Ссылка ]
🏭 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
[ Ссылка ]
🎙️ Mic Gear
Shure SM7B Cardioid Dynamic Microphone
[ Ссылка ]
Cloudlifter
[ Ссылка ]
XLR cables
[ Ссылка ]
Focusrite Audio Interface
[ Ссылка ]
📷 Camera Gear
Canon M50 Mark II
[ Ссылка ]
Micro HDMI to HDMI
[ Ссылка ]
Video capture card
[ Ссылка ]
AC Wall for constant power
[ Ссылка ]
Stay Awesome,
Hussein
