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

Home -> Community -> Mailing Lists -> Oracle-L -> Does Index get updated ??

Does Index get updated ??

From: <sat0789_at_fastmail.fm>
Date: Fri, 08 Oct 2004 15:06:25 -0700
Message-Id: <1097273185.9436.206086822@webmail.messagingengine.com>


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
Received on Fri Oct 08 2004 - 17:01:54 CDT

Original text of this message

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