Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> REPOST: Re: tuning sql statement with bind value
Please provide an example of a SQL statement using bind variables that you
can not explain plan.
Daniel Morgan
Mike F wrote:
> I am learning the most difficult part of performance tuning.
> Almost all of our sql statement use bind values. With binding
> variables in your sql statement, oracle does not allow you to explain
> plan, should i just change the sql, hard code it and explain it and
> believe that oracle will use the same execution path as the binding one?
>
> How about histograms?
> Thanks for you help.
>
>
>
> --
> Sent by dbadba62 from hotmail subpart of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 03:59:47 CST