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
Other related posts:
