Rebuild partition

  • Comments posted to this topic are about the item Rebuild partition

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

  • 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 script.

  • 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