Indexing Internals for Developers & DBAs
summary
Shows exact internals and demos: heaps always scan (example query costs 7,504 logical reads) vs a clustered seek (4 logical reads), loading a staging table drops from 65 minutes to 34 seconds by using a heap then rebuilding, rebuild itself takes 67 minutes so process changed to an incremental 5‑minute job. Uses DBCC IND/DBCC PAGE and set statistics IO to inspect pages and I/O, explains forwarding pointers, why GUID clustered keys cause splits, recommends online rebuilds, 30% fragmentation threshold, and dropping duplicate indexes that shrink a 250GB index footprint to 18GB.
AI-written summary · about
chapters (9)
- 0:00Introduction and context
- 3:35Overview of index structures
- 7:09Understanding heaps
- 14:12Clustered indexes internals
- 19:51Non-clustered index concepts
- 22:36Indexing internals demo
- 29:32Heap and index performance
- 38:50Measuring and optimizing
- 47:37Conclusion and maintenance
related talks
53mIndexing Internals for Developers & DBAs- 53mIndexing Internals for Developers & DBAs
53mSQL Server Internals: The Practical Angle
07mIndeksimi dhe përmirësimi i performancës në SQL
52mPostgreSQL Index Strategy Guide
01h 00m7 Tips to Performance Tuning, Optimization, and Everything
48mA Deep Dive Into Database Internals
41mStop Indexing the Query