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
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