Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
Stuck in Tutorial Hell? Learn Backend Dev the Right Way
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Explore the impact of index defragmentation on modern disk architecture and database performance in this 19-minute SQLBits conference talk. Gain insights into external fragmentation and its potential effects on I/O operations. Learn when to reconsider or limit index defragmentation practices to optimize database performance. Discover valuable information applicable to various SQL platforms, including SQL 2019, Azure SQL Database, Managed Instance, and SQL on Linux. Join speaker Rob Mandeville as he delves into database engine management, administration, monitoring, and optimization techniques.
Syllabus
Should We Defragment Indexes?
Taught by
SQLBits