RE: Does Index get updated ??

Tom Kyte has always advocated not updating or setting a value to the same value. So I guess the short answer is yes. But the easiest way to find out is to run a sql trace on you below statement and verify your trace file.

Regards,
pba=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sat0789_at_fastmail.fm Sent: Friday, 8 October 2004 3:06 PM
To: oracle-l_at_freelists.org
Subject: Does Index get updated ??

Hello All,
 I have a question on index update..

There is a table (say A) with 10 columns and a unique index (say column loan_key)
An informatica job updates this table with a where clause of loan_key. The job also updates loan_key column even though the value does not change. So at an oracle level i see

update a=20
set loan_key =3D 123,
b =3D bbb
c =3D ccc
where loan_key =3D 123

will this update statement also cause the index to be updated even though the column value does not change.

Thank You,

Sat
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 08 2004 - 18:23:30 CDT