SQL Server Developer Center > SQL Server Forums > Transact-SQL > Getting clustered index update in execution plan even when the field participating in clustered index is not getting updated
Ask a questionAsk a question
 

Proposed AnswerGetting clustered index update in execution plan even when the field participating in clustered index is not getting updated

All Replies

  • Wednesday, November 04, 2009 2:55 PMDaleTurley Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Proposed Answer
    I may be slightly off track but,

    The clustered index is effectivley the table - so if a column is updated, that column resides in the clustered index (as every column does) so the clustered index is technically updated.
    • Proposed As Answer bySQLUSAAnswererFriday, November 13, 2009 2:15 PM
    •