• Gail, thank you for the reply.

    GilaMonster (2/17/2012)


    Disabling it first means that the index is gone and not usable until the rebuild finished.

    It also seems likely that you'd end up with query plans that were compiled during the "no index" time frame which would need to be re-compiled once the index rebuild went into effect.

    Phil Helmer
    Database Engineer