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

YouTube

Index Fragmentation - Internals, Analysis, and Solutions

PASS Data Community Summit via YouTube

Start learning Write review
Train in Data Ad

Master Production-Ready Machine Learning, Step by Step

Learn More → CodeSignal Ad

Learn the Skills Netflix, Meta, and Capital One Actually Hire For

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course examines SQL Server index fragmentation, from page splits and their causes to measuring fragmentation and correcting it with index rebuilds. It also covers fill factor configuration and real-world examples.

Syllabus

Intro
The SQLskills Team
Overview
Index Structure
Singleton Lookup
Range Scan
Range-Scan: Readahead (1)
Logical Fragmentation Defined
Low Buffer Pool Usage
What is a Page Split?
Updates During a Page Split
Page Split Mechanism
Tracking Page Splits
What Causes Fragmentation?
Real-World Examples
Configuring FILLFACTOR
sys.dm_db_index_physical stats a
How to Correct Fragmentation?
ALTER INDEX ... REBUILD

Taught by

PASS Data Community Summit

Reviews

Start your review of Index Fragmentation - Internals, Analysis, and Solutions

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.