DBCC DBREINDEX versus DBCC INDEXDEFRAG

• tulcanla

  SSCommitted

  Points: 1541

  More actions

  October 31, 2003 at 8:53 am

  #160904

  I made some experiences with those 2 DBCC tools:

  Interesting that after I run dbreindex the snam density = 100% (very good) but the logical scan defrag it is 1.16 %

  Then I ran indexdefrag and the scan density beomes 80% ??? but thye logical scan defrag is 0.00%( excellent)

  Now, INDEXDEFRAG does not lock the tables, and is decent in using log files, but at the end of the day it is good only for correcting the logical scan defrag.

  What it is best between those 2 and could I have your comments about this topic 🙂

  Thanks all

  LMT

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  November 2, 2003 at 5:52 pm

  #480583

  The DBREINDEX is in fact a DROP INDEX followed by a CREATE INDEX.

  The INDEXDEFRAG is unable to optimize the indexes spanning over several files. In fact it is defregmenting one file at time.

  Also be aware that SQLServer will only defragment tables which are larger then 8 pages (1 extent).

  Bye

  Gabor

  
  
  Bye
  Gabor