SQL Server Performance

Clustered Index Update..

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Aston, Apr 9, 2008.

  1. Aston New Member

    UPDATE tblx SET C1 = 5, C2 = GETDATE(), C3 = GETDATE(), C4 = 2
    WHERE (C7 = 24) AND (C8 = 1)
    There is PK Clustered on column "ID". When ever we issue above statement the execution plan shows Clustered Index Update ? I have set the fillfactor=85 .
    Any suggestion ?
    Thanks
  2. MohammedU New Member

  3. MohammedU New Member

Share This Page