InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:21:19 GMT20http://www.sqlservercentral.com/Forums/Topic1059874-146-1.aspxThanks for all your repliesTue, 08 Feb 2011 08:47:21 GMTMatt-1034261http://www.sqlservercentral.com/Forums/Topic1059874-146-1.aspxAlso, also, be cognizant of the fact that just becuase you have a high cost in an execution plan, doesn't mean that the process itself is very high cost. Execution plan costs are just estimates and do not represent measures that you can use to determine performance.Tue, 08 Feb 2011 07:31:30 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1059874-146-1.aspxAlso be aware that the execution plan adds up to 100%, so something will take up resources. If you have the index on fields that the update can use, then the resource usage should be minimal.Mon, 07 Feb 2011 13:33:56 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1059874-146-1.aspxThe "clustered index" is, for all intents and purposes, the table itself. I would expect that to the majority of the work on a simple update.In other words, this is normal and expected.You'll want to take a look at how clustered indexes work. If you'll be administering or performance tuning, you'll need to know about them.Mon, 07 Feb 2011 13:21:44 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1059874-146-1.aspxHiOn our website when someone views a members image we update a field called visits which is just a counter that shows how many times an image has been viewed.The sql statement looks like this : -[code="sql"]update images set visits=visits+1 where (username=@username) AND (mykey=@mykey)[/code]However I have noticed that looking at the execution plan a clustered index update is taking place which is taking up 86%.Anyone know why this might be?ThanksMattMon, 07 Feb 2011 13:06:43 GMTMatt-1034261