Re: histograms, buckets, and bind variables

Yep, that's one of the myths spread that Oracle ignores histograms when you use bind variables. As you found out, it does not. And yes, the number of buckets matters, bind variables or not.

ryan_gaffuri_at_comcast.net 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?
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l