Home Forums SQL Server 2008 SQL Server 2008 Administration Overhead on a NC index if the key fields are not updated during production. RE: Overhead on a NC index if the key fields are not updated during production.

  • July 4, 2013 at 3:59 am

    #1629786

    SQLSACT (7/4/2013)

    Hi Gail - Just to confirm, is this part correct?

    if you are changing the Clustering key at all with your updates, all nonclustered indexes will be affected as well

    The clustered index key is present in every single nonclustered index, just like any other column for the purposes of updates.

    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