Indexing Internals for Developers & DBAs
summary
Deep dive into SQL Server index behavior with live DBCC demos showing how DBCC IND/DBCC PAGE reveal IAM pages, RID lookups and forwarding pointers; heap scans read everything (example: heap scan = 7,504 logical reads vs clustered seek at 4 reads). Real outcomes: staging load drops from 65 minutes to 34 seconds as a heap (but index rebuild was 67 minutes, leading to an incremental staging pattern), and cleaning duplicate indexes shrinks a 250 GB table to 18 GB. Uses SET STATISTICS IO/TIME, query store, DMVs and rebuild/reorganize rules (rebuild when fragmentation >30%).
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
45mA Deep Dive into PostgreSQL Indexing
52mPostgreSQL Index Strategy Guide
01h 00m7 Tips to Performance Tuning, Optimization, and Everything
33mDriver for Data-Driven Change