Indexing Internals for Developers & DBAs

on YouTube ↗53m

" summary

Covers how heaps, clustered and non‑clustered indexes behave with concrete measurements and fixes: uses DBCC IND/DBCC PAGE, DMVs, Query Store, set statistics IO/time and drop clean buffers. Shows a staging load cut from 65 minutes to 34 seconds but rebuild costs 67 minutes so the final solution is incremental loads totaling ~5 minutes. Demonstrates a heap scan costing 7,504 logical reads -> clustered seek at 4 reads, finds duplicate indexes and shrinks a 250 GB index set to 18 GB.

AI-written summary · about

" chapters (9)

1. 0:00Introduction and context
2. 3:35Overview of index structures
3. 7:09Understanding heaps
4. 14:12Clustered indexes internals
5. 19:51Non-clustered index concepts
6. 22:36Indexing internals demo
7. 29:32Heap and index performance
8. 38:50Measuring and optimizing
9. 47:37Conclusion and maintenance

" related talks

• 53mIndexing Internals for Developers & DBAsBradley Ball · SQLBits 2022
• 53mIndexing Internals for Developers & DBAsBradley Ball · SQLBits 2019
• 53mSQL Server Internals: The Practical AngleDmitri Korotkevitch · 24 Hours of PASS: Summit Preview 2015
• 07mIndeksimi dhe përmirësimi i performancës në SQLGent Bicaj · debugCon Mars 2019
• 01h 00m7 Tips to Performance Tuning, Optimization, and EverythingPinal Dave · 24 Hours of PASS: Summit Preview 2015
• 41mStop Indexing the QueryRob Mandeville · SQLBits 2019
• 52mPostgreSQL Index Strategy GuideGreg Dostatni · Postgres Conference Orlando 2025
• 45mA Deep Dive into PostgreSQL IndexingIbrar Ahmed · PGConf NYC 2021