InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:30:48 GMT20http://www.sqlservercentral.com/Forums/Topic1363813-1550-1.aspxAbsolutely. Has to be, otherwise the nonclustered indexes don't match the table (and that's called corruption). Could be more than that if there is an index on that column as the non-leaf levels may need updating too.Tue, 25 Sep 2012 04:18:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1363813-1550-1.aspxThat is correct but how it will do? Say in our case TestTable if we update DeptID of any user then the actual data page of clustered index will be updated first (this is the only actual physical page), and question comes to Non-clustered will the Depid also update at the non-clustered leaf level?That means two updates at page levels?Thank youTue, 25 Sep 2012 04:03:52 GMTSQL*http://www.sqlservercentral.com/Forums/Topic1363813-1550-1.aspxDuring the execution of the insert/update/delete always. A nonclustered index is never out of date.Tue, 25 Sep 2012 01:19:38 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1363813-1550-1.aspxHi All,Basic question is: When does the non-clustered index update (when we do any updates on table)?We have created a non-clustered index, when we update the table's column which is the key of non-clustered index then the execution plan is showing only clustered index update. What about the non-clustered index update? How the non-clustered index key values modified?Include Column index:If we have a non-clustered index by including the columnEx: TestTable -- id int P.K, Name varchar(50), DeptID INTi have created non-clustered index on Name by including the DeptIDcreate index idx_nameon TestTable (Name) Include (Deptid)that means the non-clustered index leaf level pages contains DeptID also.My Question is when we update Deptid column of TestTable, how the non-clustered index leaflevel will be updated? Will this non-clustered index update? my execution plan is not showing the non-clustered update.Please find the attached scripts/execution plan of update statement.Tue, 25 Sep 2012 00:44:21 GMTSQL*