Hi All,
Oracle 8.0.5
HP 11.0
Oracle Apps 11.0.3
What happens if we analyze the database on rule based optimizer?
I have an Apps database with optimizer init parameter set to 'rule' and has
some statistics in it ( previous DBA set this up). I have noticed that with
statistics it seems to be using cost base optimizer because the query plan
changes during different sampling period. I deleted the statistics from the
database and the query plan became horrific with full table scans all over
the place.
Can anybody explain to me what is going on here?
TIA
Dennis
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.net
--
Author: Meng, Dennis
INET: Dennis.Meng_at_alcoa.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Fri Apr 25 2003 - 10:27:00 CDT
