Re: histograms, buckets, and bind variables
- From: Natural Join B.V. <lex.de.haan@xxxxxxxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Nov 2004 17:27:11 MET
I could swear that you are experiencing the great Oracle feature called "bind
peeking" at work ...
Cheers,
Lex.
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » histograms, buckets, and bind variables
- » RE: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » RE: histograms, buckets, and bind variables
- » RE: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » RE: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables
- » RE: histograms, buckets, and bind variables
- » Re: histograms, buckets, and bind variables