RE: rm RULE based optimizer != GOOD IDEA
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: "z b" <zimsbait@xxxxxxxxx>
- Date: Fri, 22 Apr 2005 10:53:44 -0500
Again, to set that for this individual SQL statement I would need to
find some crafty place to put a trigger, doing it at the DB level risks
plan changes for 1000's of other statements.
-----Original Message-----
From: z b [mailto:zimsbait@xxxxxxxxx]=20
Sent: Friday, April 22, 2005 10:48 AM
To: Post, Ethan
Cc: CMarquez@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: rm RULE based optimizer !=3D GOOD IDEA
Of course, they're getting rid of LONG's also. ;-)
Someone else mentioned the i_o_c_a as a potential plan changer. Try to
alter=20
a session with a lower value for i_o_c_a and explain/autotrace the
query again. I have seen some of our queries "magically" change from
fts to irs.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
