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

From: Greg Rahn <>
Date: Thu, 8 Jan 2009 13:16:17 -0800
Message-ID: <>

On Thu, Jan 8, 2009 at 12:11 PM, Jared Still <> 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.

There are other "clever tricks" like looking at the extent map in certain cases.

Greg Rahn
Received on Thu Jan 08 2009 - 15:16:17 CST

Original text of this message