Re: Statistics and optimizer

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 4 May 2001 10:39:34 +0100
Message-ID: <988969179.3860.0.nnrp-01.c30bdde2@news.demon.co.uk>

It defaults back to rule-based - what you might call the 'default values' - if no statistics are present.

(message converted to plain text)

""Ann Myhre"" <annmyhre_at_hotmail.com> wrote in message news:OE7b4uFM5NKGfVNMnfi00002744_at_hotmail.com... Does anyone know if optimizer will use the costbased method if no statistcis is gathered (ANALYZE TABLE etc.)? I have information saying that if no statistics is gathered, optimizer will choose the rulebased method, and another source saying that then will optimizer (if set to CHOOSE) choose some default values includes in Oracle. Help anyone?

Ann Received on Fri May 04 2001 - 04:39:34 CDT