Re: Freezing database statistics

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 3 Nov 2006 22:19:05 -0000
Message-ID: <iu2dnfBBkokuXdbYnZ2dnUVZ8sGdnZ2d@bt.com>

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message news:454bbbb8.1436875_at_news.hetnet.nl...
> I wonder: will Oracle only use statistics that are gathered with the
> ANALYZE statement or DBMS_STATS, or also take other things into
> account, for instance the highwater mark of a table?
>
> If so, this cannot be frozen, so access plans could change even with
> frozen statistics.
>
> Regards, Jaap.

I haven't check 10g, but as of 8i and 9i the optimizer only checked the HWM if there
were no stats on the table

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Fri Nov 03 2006 - 16:19:05 CST