Insight: updating a row by primary key setting primary key cause index changes

From: <jcl_at_lightspeed.net>
Date: 1998/04/22
Message-ID: <6hmc5u$jtr$1_at_nnrp1.dejanews.com>#1/1


If one updates a row setting all values in a row including the primary key, does this cause oracle to recalc its indexes even thought the values are the same. I would think oracle would notices this. If this is so one could get better performance by not setting these values. example:
Table x {
 PrimaryKey name,
 ssn
}

update table x set name = 'Joe' , ssn = 10 where name = 'Joe';

Thanks , 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 Wed Apr 22 1998 - 00:00:00 CEST

Original text of this message