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: HansF <News.Hans_at_telus.net>
Date: Fri, 09 Sep 2005 20:23:08 GMT
Message-Id: <pan.2005.09.09.20.27.32.799746@telus.net> 





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


-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***


Received on Fri Sep 09 2005 - 15:23:08 CDT












Original text of this message













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