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.
SQLSACT
SSC-Insane
Points: 21838
More actions
July 3, 2013 at 7:08 am
#1629516
As far as I understand, unless the index is filtered, all inserts/updates/deletes will affect all nonclustered indexes.
Think in a row level, not just on a field level
EDIT - I might be and probably am wrong about the updates though.