Post reply

Diff between offline and online index rebuild operation

  • September 19, 2014 at 6:39 am

    #290096

    Hi,

    Can anyone please tell me the difference between OFFLINE Index rebuilds and ONLINE Index rebuilds? which one is good over the other?

    Thanks

  • September 19, 2014 at 6:43 am

    #1746695

    Offline = index unavailable for the duration of the operation

    Online = index is available for most of the duration of the operation, more resources required, may take longer than an offline rebuild.

    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

  • September 19, 2014 at 12:27 pm

    #1746809

    Thank you.

  • September 19, 2014 at 12:34 pm

    #1746811

    How about single threaded vs multi-threaded performance on index rebuilds off-line vs on-line?

  • September 19, 2014 at 3:44 pm

    #1746835

    I believe they can both run in parallel.

    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

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

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