Need help

Hi all,

         Can anyone tell me which of the following performs better in collecting statistics of a table:  Analyze command or
 Dbms_stats.gather_table_stats  

      I tried my queries with both the options -- but always Analyze is out-performing the dbms_stats. But i read in a document that Dbms_stats performs better !! Besides I also read that Analyze command will be deprecated from Oracle 9i.  

 So can anyone tell me why dbms_stats is performing poor...  Are there any paramters that need to be set to increase the performace of dbms_stats ?  

Thanks in advance.  

Regards
Kesh  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jayaram Keshava Murthy (Cognizant)
  INET: JKmurthy_at_chn.cognizant.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).



text/plain attachment: InterScan_Disclaimer.txt