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 3, 2013 at 9:21 am

    #1629577

    AFAIK, Gail is correct. If the columns in the NC index are not changed with an update, that index is not touched. No reason to, as there's nothing to update.