Should We Defragment Indexes?

You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.
Speaker: Rob Mandeville SQLbits.com/sp...
SQLbits.com/Ses...
Tags: SQL 2019,Azure SQL Database,Managed Instance,Database engine,Database Administration,Managing,Monitoring,Optimising,SQL 2022,Platform Agnostic,SQL on Linux

[@larsrasmussen5263]

Is allowing excessive external fragmentation in order to leverage additional caching and storage groups mostly a cloud secret? This makes sense and it seems like more data folks need to know.

[@peteiscurious]

thanks...so as conclusion, we should not consider rebuilding indexes?