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

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO histograms and bind variable

Re: CBO histograms and bind variable

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sat, 11 Oct 2003 20:55:37 +0200
Message-ID: <vfkgov4dobcrjehd2lgamq57899vdckj6v@4ax.com> 





On Sat, 11 Oct 2003 21:33:32 +0300, "Jarmo Blomster"
<jarmo.blomster(RMVE.N0SPM)@mbnet.fi> wrote:



>Hi,

>

>Can Oracle CBO utilize histograms when I use bind variables in SQL-query?

>Is there differences between versions 8 and 9?

>

>//jarmo

>




CBO doesn't use histograms in version 8i. CBO should be capable to
'peek' in bind variables in 9i



--
Sybrand Bakker, Senior Oracle DBA


Received on Sat Oct 11 2003 - 13:55:37 CDT












Original text of this message













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