Index Update

• Ashok Jebaraj

  Ten Centuries

  Points: 1215

  More actions

  August 1, 2006 at 2:55 am

  #61691

  Consider a table T1 which has a nonclustered index IX_C2 on column C2 and has no clustered index. When T1.C2 is updated, is the table value updated first and then the index IX_C2 or vice versa.

• August 4, 2006 at 8:00 am

  This was removed by the editor as SPAM

• WesleyB

  Ten Centuries

  Points: 1307

  More actions

  August 4, 2006 at 2:54 pm

  #653437

  Since they say in SQL Server 2005 indexes don't get updated when you update a field with the same value I'm assuming first data and then index.