Re: tuning sql statement with bind value

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 25 Jan 2002 09:59:47 +0000
Message-ID: <3C512C93.D761B120@exesolutions.com>

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
Received on Fri Jan 25 2002 - 03:59:47 CST