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 -----Original Message-----
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', - Am I missing something? Aren't both commands the same?
Thanks, Tom |
Title: Message
- RE: dbms_stats Trassens, Christian
- Re: dbms_stats paquette stephane
- RE: dbms_stats Trassens, Christian
- DBMS_STATS Anand Prakash
- Re: DBMS_STATS Christian Trassens
- Re: DBMS_STATS Anand Prakash
- Re: DBMS_STATS Christian Trassens
- DBMS_STATS Scott Bunnett
- RE: DBMS_STATS ayyappan . subramaniyan
- DBMS_STATS Terrian, Tom (Contractor) (DAASC)
- RE: DBMS_STATS Cary Millsap
- RE: DBMS_STATS Terrian, Tom (Contractor) (DAASC)
- Re: DBMS_STATS Tim Gorman
- RE: DBMS_STATS Jesse, Rich
- Re: DBMS_STATS babu . nagarajan
- RE: DBMS_STATS Cary Millsap
- Re: DBMS_STATS Jonathan Lewis
- RE: DBMS_STATS Johnston, Tim
- RE: DBMS_STATS Jay Hostetter
- Re: DBMS_STATS Jonathan Lewis
- RE: DBMS_STATS Terrian, Tom (Contractor) (DAASC)