Post reply

Rebuild partition

  • March 2, 2010 at 5:38 pm

    #217225

    Comments posted to this topic are about the item Rebuild partition

  • March 12, 2010 at 4:48 am

    #1132578

    Can you explain the benefit of this approach in comparison to using: ALTER INDEX REORGANIZE - which can be done online to a partitioned index?

  • March 12, 2010 at 5:24 am

    #1132592

    Reorganize is online , but sometime is necessary to rebuild an index, and rebuilding a given partition of a given index cannot be done online.

    You could always rebuild online partition=all, but why rebuild all ?

  • May 19, 2016 at 7:18 am

    #1880232

    Thanks for the script.

  • May 19, 2016 at 7:18 am

    #1880233

    Federico Iori (3/12/2010)

    Reorganize is online , but sometime is necessary to rebuild an index, and rebuilding a given partition of a given index cannot be done online.

    You could always rebuild online partition=all, but why rebuild all ?

    Thanks for the explanation.

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

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