Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: histograms, buckets, and bind variables

RE: histograms, buckets, and bind variables

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 17 Nov 2004 17:28:13 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6AB16@MSXVS02.trivadis.com>


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
Received on Wed Nov 17 2004 - 10:43:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US