Q:Do you take an INDEX hit if you update the primary key with the same values.

I was wondering if you take an index hit if the update statement sets the primary key to the same value it was before the update. If so then I would assume that leaving out the primary key would make the statement faster.

Ex:
Table XX

   Col pp - primary key.
   Col yy

Update table xx set values pp = 'Test' , yy = 'uu' where pp = 'Test'; Thanks for the replys.

jcl.

jcl_at_lightspeed.net

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 23 1998 - 10:00:03 CDT