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: Oracle CBO query cost - retrieve value?

Re: Oracle CBO query cost - retrieve value?

From: <csn233_at_gmail.com>
Date: Sun, 07 Oct 2007 11:08:49 -0700
Message-ID: <1191780529.601773.36120@o3g2000hsb.googlegroups.com> 





Urm, Morgan, you didn't really think that was a question on syntax,
did you?



To the OP, don't look at cost. It is not for consumption by the enduser.




You have a bind-variable peeking problem.



Construct say 3 different cursors each with a different stabilised
plan based on selectivity of the inputs, and call the appropriate
cursor based on the input variable. Or reject it altogether.



Comes down to: know your data.
Received on Sun Oct 07 2007 - 13:08:49 CDT












Original text of this message













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