RE: histograms, buckets, and bind variables

Hi Ryan

When histograms are gathered the column statistic DENSITY is computed = differently.
Thus, even if the histograms themselves are not used, gathering = histograms has an impact on query using bind variables as well...

Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
>ryan_gaffuri_at_comcast.net
>Sent: 17 November 2004 17:07
>To: oracle-l_at_freelists.org
>Subject: histograms, buckets, and bind variables
>
>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

--
http://www.freelists.org/webpage/oracle-l