RE: Does Index get updated ??

From: Bach, Peter <PBach_at_ea.com>
Date: Tue, 12 Oct 2004 04:57:00 +1000
Message-ID: <18BB83888156DA42A09F76AF88C64E60021C6D2F@bodie.aaa.ad.ea.com>

Sorry, didn't clarify previous e-mail in enough details - with sql trace I was referring to event 10046 (extended sql trace).

Regards,
pba

-----Original Message-----
From: zhu chao [mailto:zhuchao_at_gmail.com]=20 Sent: Friday, 8 October 2004 5:52 PM
To: Bach, Peter
Cc: sat0789_at_fastmail.fm; oracle-l_at_freelists.org Subject: Re: Does Index get updated ??

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.

>=20

> Regards,
> pba=3D20

>=20
>=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 ??

>=20

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

>=20
> 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

>=20

> update a=3D20
> set loan_key =3D3D 123,
> b =3D3D bbb
> c =3D3D ccc
> where loan_key =3D3D 123

>=20

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

>=20

> Thank You,

>=20

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

>=20
>=20
>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Regards
Zhu Chao
www.cnoug.org

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

Received on Mon Oct 11 2004 - 13:52:41 CDT