| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: analyze table versus DBMS_STATS.GATHER_TABLE_STATS(...)
That shouldn't be terribly surprising. I'm not sure what books you are
referring to-- they may be stating that they server the same purpose.
Oracle has deprecated the use of the ANALYZE command and recommends that you use the DBMS_STATS package to gather statistics. In addition to being able to operate in parallel, DBMS_STATS generally gathers "better" statistics than ANALYZE.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Raphael A. Bauer
Sent: Tuesday, July 06, 2004 2:15 AM
To: oracle-l_at_freelists.org
Subject: analyze table versus DBMS_STATS.GATHER_TABLE_STATS(...)
Hi Folks,
I got a really interesting topic about 9i. I encountered a big difference in the performance of my sql commands wether I use analyze table (..) or DBMS_STATS.GATHER_TABLE_STATS(...) (both "full" analyzes). DBMS_STATS is in my case about 40secs faster than analyze... The plan of both sql queries stayed the same, only the costs differed a bit. My Oracle Books say that DBMS_STAT and analyze.. are qute the same. But that's not reality... A - I forgot - my test schema is only one simple table. Nothing to do with partitions or more complex topics...
I don't want to show you my exact tables and queries. They are not so important. More important is: Where are those 40secs hidden - and what is the real difference of DBMS_STATS.GATHER_TABLE_STATS and analyze.
Thanks a lot!
Raphael
 |
 |