Home Forums SQL Server 2005 Administering Does rebuilding a clustered index effect non clustered index. RE: Does rebuilding a clustered index effect non clustered index.

  • December 1, 2011 at 12:59 pm

    #1415528

    It'll have absolutely no effect on the nonclustered indexes. Nonclustered indexes use the clustered index key as a 'pointer' and that doesn't change in a rebuild.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass