Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insight: updating a row by primary key setting primary key cause index changes

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US