Thanks guys for the response

I fixed the issue by rearranging the query. But it is surprising that a
query has different execution plan in 8i and 9i.

Regards,
Shahed Baig . M





"Sanjaya Balasuriya " <sanjaya.[Email address protected]
26/01/2005 10:37


To: SHAHED.[Email address protected]
cc:
Subject: RE: Query issue in 9i


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi Shahed,

Gather statistics using dbms_stats package.


Thanks & Regards.

Sanjaya

Sanjaya Balasuriya
BSc (Hons) IS | Systems Engineer

Informatics International Ltd,
89/57, Jampettah Lane, Colombo 13, SRI LANKA
Office : (+94)-114-794 976
Mobile : (+94)-776-124 957
Mailto : sanjaya.[Email address protected]

-----Original Message-----
From: Shahed
[mailto:oracledba-ezmlmshield-x23346837.[Email address protected]
Sent: Tuesday, January 25, 2005 12:32 PM
To: LazyDBA Discussion
Subject: Query issue in 9i

Hi gurus,

I have migrated from 8i to 9i. There is a query which was quite faster in
8i
(1sec) but it became slow in 9i (1 min).
I ran the explain plan. The position value is as follows
in 8i Cost =1846
in 9i Cost = 93241102

pls suggest how to fix this issue

Both have optimizzer_mode set to "choose".

Regards,
Shahed Baig . M







Oracle LazyDBA home page