If the objects in a query have not been analyze, then rule mode is
defaulted.
If there are objects in the database which are analyze, yet the tables you
are using are not analyzed, rule mode will still be used.
If one table is analyzed, and it is joined with 5 others which are not
analyzed, then cost base will be used.
There are a few parameters that need tweaking when you first go from rule to
cost base.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Thursday, August 16, 2001 4:46 AM
To: Multiple recipients of list ORACLE-L
Hi list,
a quick question about oracle optimizer.
a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was
transfered via full exp/imp. After migration the performance of the new
database is very poor. I looked at the parameters and saw that no object is
analyzed. So now me question:
What does oracle optimizer do, if there are no statistics on all objects.
Optimizer level is choose.
Volker Sch�n
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schoen Volker
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
