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: Ganesh Raja <ganesh.raja_at_gmail.com>
Date: Wed, 17 Nov 2004 16:27:25 +0000
Message-ID: <f754edf04111708273dad3f14@mail.gmail.com>


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_at_comcast.net <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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 17 2004 - 10:42:26 CST

Original text of this message

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