Re: immediate value vs bind variable

From: Syltrem <syltremspammenot_at_videotron.com>
Date: Wed, 17 Jul 2002 09:27:46 -0400
Message-ID: <ggeZ8.6371$H67.33677@tor-nn1.netcom.ca>

> Posting a version is asked too much I guess.
No it does not. Simply forgotten.
8.1.6.0
Also I'm using CBO

> Details about this issue can be found in 'Designing Oracle for
Performance'
> aka the performance tuning manual, and in numerous posts in the google
> archives that no one cares to search.

I did look there but didn't find anything yet, that would answer my question.
I will have a look at the manual.

>
> The issue is the CBO (until I believe 8.1.7 EE) can't 'look' into bind
> variables and hence can't check the content of the bind variable against
> histograms present. Of course if you never did create histograms, it
> wouldn't make any difference.
>

I don't have histograms.

Thanks for your time.

> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Wed Jul 17 2002 - 08:27:46 CDT