Re: histograms, buckets, and bind variables

From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
To: ryan_gaffuri@xxxxxxxxxxx
Date: Wed, 17 Nov 2004 16:27:25 +0000

During an Hard Parse the Histogram does make a difference but it
should not after that if you are using Bind variables ...

So if you see a diffeent plan everytime it is Hard Parsed with
different values then yes that is valid. If you set an Event and Run a
Query i think it is always hard parsed.

Rgds
Ganesh

On Wed, 17 Nov 2004 16:06:40 +0000, ryan_gaffuri@xxxxxxxxxxx
<ryan_gaffuri@xxxxxxxxxxx> wrote:
> I could have swarn I read that if you use bind variables oracle ignores 
> histograms. We are noticing different query plans based on the number of 
> buckets our histograms have while our queries are using bind variables.
> One of the guys did a 10053 trace and added up the cost oracle is calculating 
> and it is changing based on number of buckets even when bind variables are 
> used.
> 
> anyone else notice this?
> 
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l

References:
- histograms, buckets, and bind variables
  - From: ryan_gaffuri

Re: histograms, buckets, and bind variables

Other related posts: