Oracle-L: RE: DBMS_STATS vs. analyze

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Tue, 06 May 2003 10:32:11 -0800
Message-ID: <F001.005916AD.20030506103211@fatcity.com>

In one 8.1.7.2 instance, differences between the generated stats caused very bad explain plans with DBMS_STATS and "nice" plans with ANALYZE. Granted, the real answer was probably to change the SQL, but that's not an option for this 3rd party software.

Login to your fatcity.com account and search for the thread titled "Burned by DBMS_STATS **AGAIN**" for more on this. The thread is about a month old.

Enjoy!

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Tuesday, May 06, 2003 9:52 AM
To: Multiple recipients of list ORACLE-L

This is an old and probably stupid question, but Im on a new project and they are using Analyze. Im trying to get them to switch to DBMS_STATS please let me know if my argument is correct. Need to be able to articulate this adequately.

DBMS_STATS is faster
the statistics gathered are better
you can use histograms and I believe I may have identified some areas where they would be appropriate.

anything I missed? Ive pointed them to asktom also. Any other good sources to point them to?
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.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 Tue May 06 2003 - 13:32:11 CDT