Re: bind variable peeking and regular statistics gathering

On 5/31/07, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
>
>
> i'm not sure about the relation between bind variable peeking and
> invalidation in the regard of regularly gathering statistics.
>
> will the bind variable peeking will re-peek when invalidation occurs
> after gathering statistics?

I'm no CBO expert, nor do I play one on TV.

That does however sound like a reasonable assumption.

Should be easy to test, no?

Perhaps you could share your test results.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l