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

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

Re: Does Index get updated ??

From: zhu chao <zhuchao_at_gmail.com>
Date: Sat, 9 Oct 2004 08:52:02 +0800
Message-ID: <962cf44b04100817526d8445fa@mail.gmail.com>


no, the index file is not updated when the loan key is the same. you can alter index tablespace read only and verify it. I don't think sql_trace will show you the whether the index is updated or not.

On Sat, 9 Oct 2004 09:27:50 +1000, Bach, Peter <pbach_at_ea.com> wrote:
> 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
>

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 08 2004 - 19:47:40 CDT

Original text of this message

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