Home Forums SQL Server 7,2000 Performance Tuning Reindexing & defragmentation RE: Reindexing & defragmentation
Steve Jones - SSC Editor
SSC Guru
Points: 734418
More actions
February 18, 2008 at 9:40 am
#779379
How are you reindexing? There is reindexing and rebuilding, which operate differently. Read the BOL entries and you'll see that one handles fragmentation.
How do you defragment? You rebuild the index.