Re: CBO Question - Is 'monitoring' used to calculate query plan?

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 8 Jan 2009 16:55:26 -0800

On Thu, Jan 8, 2009 at 1:16 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:

> On Thu, Jan 8, 2009 at 12:11 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
> > It still doesn't answer the question however of "Does the CBO use the
> stats
> > seen in all_tab_modifications for query plans?"
> I'm quite certain the answer is no - it is only used by dbms_stats to
> determine stale objects.

Thanks Greg, that's what I wanted to know.

I could probably devise a test for it, but asking someone who knows is often
sufficient.  :)


Other related posts: