Rebuild partition

  • Federico Iori

    SSCommitted

    Points: 1625

    Comments posted to this topic are about the item Rebuild partition

  • sparky-407434

    Say Hey Kid

    Points: 701

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

  • Federico Iori

    SSCommitted

    Points: 1625

    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 ?

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    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 5 (of 5 total)

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