RE: Does Index get updated ??
- From: "Bach, Peter" <PBach@xxxxxx>
- To: "zhu chao" <zhuchao@xxxxxxxxx>, <sat0789@xxxxxxxxxxx>
- Date: Tue, 12 Oct 2004 04:57:00 +1000
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@xxxxxxxxx]=20
Sent: Friday, 8 October 2004 5:52 PM
To: Bach, Peter
Cc: sat0789@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
sat0789@xxxxxxxxxxx
> Sent: Friday, 8 October 2004 3:06 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
>=20
>=20
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
