Re: Freezing database statistics

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sat, 04 Nov 2006 10:14:56 GMT
Message-ID: <454c67ea.90546@news.hetnet.nl>

On Fri, 3 Nov 2006 22:19:05 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>"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
>
>
>

Okay, thanks. Good to know.

Regards,

Jaap. Received on Sat Nov 04 2006 - 04:14:56 CST