Microsoft SQL Server 2000 Index Defragmentation Best Practices
By Bill Graziano
on 2 May 2004
| 0 Comments
| Tags: Indexes
As Microsoft SQL Server 2000 maintains indexes to reflect updates to their underlying tables, these indexes can become fragmented. Depending on workload characteristics, this fragmentation can adversely affect workload performance. This white paper provides information to help you determine whether you should defragment table indexes to benefit workload performance. To defragment indexes, SQL Server 2000 provides several statements. This white paper compares two of those statements: DBCC DBREINDEX and DBCC INDEXDEFRAG. Follow the link to Microsoft SQL Server 2000 Index Defragmentation Best Practices...