RE: DBMS_STATS

[Terrian, Tom (Contractor) (DAASC)]

Title: Message

ok, I will take a look.  thanks -----Original Message----- From: Cary Millsap [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBMS_STATS May have something to do with bug 2649728, which I just heard about for the first time no more than 10 seconds ago.   Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terrian, Tom (Contractor) (DAASC) Sent: Tuesday, February 25, 2003 12:13 PM To: Multiple recipients of list ORACLE-L Subject: DBMS_STATS   I have never had good luck with DBMS_STATS.  It seems that the old analyze runs much faster.....   Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statistics sample 5 percent;    Takes over 2 hours: execute dbms_stats.gather_table_stats(ownname => 'LDGADMIN', -                                       tabname => 'LOG_TRANS', -                                       partname => 'LOG_TRANS_20030102', -                                       estimate_percent => 5); Am I missing something?  Aren't both commands the same?   Thanks, Tom