phelmer (2/21/2012)
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.
Rebuild would invalidate the plans anyway
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability