RE: rm RULE based optimizer != GOOD IDEA

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 22 Apr 2005 10:53:44 -0500
Message-ID: <E5D2567DDF0D03428A15664A78CA473C3B608A@pscdalpexch02.perotsystems.net>

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_at_gmail.com]=20 Sent: Friday, April 22, 2005 10:48 AM
To: Post, Ethan
Cc: CMarquez_at_aarp.org; oracle-l_at_freelists.org 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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 22 2005 - 12:10:25 CDT