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. :) Jared