[WEBINAR] Better to Ask Permission? Best Practices for Privacy and Security

Index Defragmentation

Definition - 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.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.