Diff between Index Defrag and Index Rebuild

• U J

  SSCrazy

  Points: 2423

  More actions

  January 5, 2007 at 5:28 am

  #171734

  Hi all,

  please can anybody tell me the

  Diff between DBCC INDEXDEFRAG and DBCC DBREINDEX ?

  or is ther any good article for the same?

   

  Thks  a lot for any help.

   

  Thnks & Regards,

  Tushar

• Leeland

  SSCrazy Eights

  Points: 8959

  More actions

  January 5, 2007 at 10:32 am

  #681529

  Google is your friend

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

• U J

  SSCrazy

  Points: 2423

  More actions

  January 6, 2007 at 12:24 am

  #681622

  thks a lot Lee....

  the link is really nice & useful

• Leeland

  SSCrazy Eights

  Points: 8959

  More actions

  January 6, 2007 at 10:12 pm

  #681662

  No Problem...glad to help