Index Defragmentation

What Does Index Defragmentation Mean?

Index defragmentation is a part of Microsoft SQL Server maintenance where the index of database engine indexes of insert, update and delete operations is optimized to reduce fragmentation. This is done by reorganizing or rebuilding an index on an entire index or a single partition. Defragmentation improves disk space and performance of SQL Server.


Techopedia Explains Index Defragmentation

Microsoft SQL Server maintains indexes of all the insert, update and delete operations performed on databases. Over time, these indexes can become fragmented or stored out of order on the database server’s disks. This wastes disk space and can slow down database access operations. Fortunately, SQL Server offers tools to detect and repair fragmentation.

Index defragmentation is done through the SQL Server Management Studio and Transact-SQL. The indexes are defragmented by reorganizing or rebuilding an index. Indexes can also be rebuilt for individual tables for a database. Defragmentation makes sure that all the entries in an index are contiguous for faster and more efficient access instead of being spread out across multiple disks and partitions. It is similar to defragmenting files on a hard drive.


Related Terms

Latest Database Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…