Post reply

dbcc indexdefrag vs reorganize

  • December 16, 2012 at 9:38 pm

    #272190

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

    I am using sqlserver2005 and 2008 r2 versions

  • December 16, 2012 at 10:29 pm

    #1569013

    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;-)

  • December 17, 2012 at 12:56 am

    #1569029

    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

  • December 17, 2012 at 1:45 am

    #1569038

    Thanks gail

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

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