Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: using bind variables makes the optimizer choose a bad plan

Re: using bind variables makes the optimizer choose a bad plan

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 10 Sep 2005 12:47:41 +0200
Message-ID: <dfud5v$q1v$1@news2.zwoll1.ov.home.nl>


HansF wrote:
> On Fri, 09 Sep 2005 13:15:52 -0700, Daniel Fink amused us by writing:
>
>

>>There is not an absolute "Bind Variables are always GOOD|BAD" rule.
>>They are 'usually' a good thing, but not always.

>
>
> Aw, gee whiz ... that means we gotta test in our environment to see
> whether it's good or bad then! No Rule Of Thumb (ROT)? ;-Q
>

The only true ROT seems TTT.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Sep 10 2005 - 05:47:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US