dbcc indexdefrag vs reorganize

  • dbcc indexdefarg or reorganize which one i need to use in production ?

    I am using sqlserver2005 and 2008 r2 versions

  • first you need to know what are these two terms

    see link http://realworlddba.wordpress.com/2008/02/04/index-rebuild-versus-reorganize-whats-the-difference/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Firstly, stop using the DBCC commands, they're deprecated, included only for backward compatibility with SQL Server 2000 and should not be used in new development. The replacements are ALTER INDEX ... REBUILD and ALTER INDEX ... REORGANIZE

    As for which you use, it is quite complex and there are a lot of considerations. I would suggest, to make index maintenance easier you grab Ola's index maintenance script: http://ola.hallengren.com/versions.html

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks gail

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply