Re: histograms, buckets, and bind variables

From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
To: <ryan_gaffuri@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 17 Nov 2004 12:27:51 -0400

Hi Ryan
In Oracle 9i if there are histograms, even if it is binded it uses
histograms anyway.

 
Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 
From: ryan_gaffuri@xxxxxxxxxxx
Date: 11/17/04 12:24:30
To: oracle-l@xxxxxxxxxxxxx
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?
 
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

References:
- histograms, buckets, and bind variables
  - From: ryan_gaffuri

Re: histograms, buckets, and bind variables

Other related posts: