Re: Oracle CBO query cost - retrieve value?

On Oct 8, 12:09 pm, cleveridea <cleveridea...._at_gmail.com> wrote:
> On Oct 7, 4:37 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > csn..._at_gmail.com wrote:
> > > 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 end-
> > > user.
>
> > > 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.
>
> > Given the syntax error ... you are assuming that what you are seeing
> > is the real statement. I'm not willing to make that assumption.
>
> > The OP has now stated: "I anonymised & simplified the query data
> > incorrectly" so, given that it has been simplified, the real issue
> > may bear no relationship to what has been posted.
>
> > To the OP. Anonymizing, ok, rename the tables and columns if you wish.
> > But simplifying makes the exercise meaningless.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org
>
> Daniel why don't you just ignore such posts that are so problematic to
> you? Why do you continually waste everyone's time posting how bad
> other people's posts are

Not answering for Daniel, but rather in general:

It's not a waste of time to present feedback on a question. A bad question helps no one, and may indeed hinder people by both being a bad example for others to emulate and propagating misinformation or bad assumptions. There are such things as bad questions, that's why there are postings on how to ask a good question (like http://www.dbaoracle.net/readme-cdos.htm#subj12 feedback appreciated). There may be better ways to present constructive criticism, but that applies to all of us. Rather than telling Daniel to ignore such posts, try giving him better ways of answering them. He's been around here a long time, so perhaps he's set in his ways, but he's also an instructor, and presumably receptive to usable suggestions on how to get good information propagated.

jg

--
@home.com is bogus.
"Give a Filipino a dog and you've fed him for a day.  Teach a Filipino
to hunt dogs and you've fed him for a lifetime." - Ralph Garman (after
reporting stories about PETA wanting Britney's dogs taken away and
Filipinos upset about a "Filipino medical school" line on Desperate
Housewives).  He also voices a dog on Family Guy, most recently seen
eating discarded human legs.