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