Re: bind variable peeking and regular statistics gathering
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: ujang.jaenudin@xxxxxxxxx
- Date: Thu, 31 May 2007 10:01:35 -0700
On 5/31/07, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> 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
- References:
- bind variable peeking and regular statistics gathering
- From: Ujang Jaenudin
Other related posts:
- » bind variable peeking and regular statistics gathering
- » Re: bind variable peeking and regular statistics gathering
- » Re: bind variable peeking and regular statistics gathering
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?
- bind variable peeking and regular statistics gathering
- From: Ujang Jaenudin