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:43 am
#1629533
Keep in mind that if you are changing the Clustering key at all with your updates, all nonclustered indexes will be affected as well