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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy