Does Index get updated ??

From: sat0789@xxxxxxxxxxx
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 08 Oct 2004 15:06:25 -0700

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 
set loan_key = 123,
b = bbb
c = ccc
where loan_key = 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

Follow-Ups:

Re: Does Index get updated ??
From: Edgar Chupit

References:
- MERGE statement internals
  - From: Edgar Chupit
- Re: MERGE statement internals
  - From: Juan Carlos Reyes Pacheco

Does Index get updated ??

Other related posts: