RE: What are the implications of running dbms_stats and analyze compute?

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <achoto@xxxxxxxxxxxx>, "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Tue, 9 Aug 2005 09:16:28 -0700


There is no problem with having a combination of tables/indexes analyzed with 
both dbms_stats and analyze.  For the most part, they are just two different 
ways of doing the same thing.  If your developers insist on ANALYZE, ask them 
to prove why it is needed instead of dbms_stats.  If they don't have any better 
answer than "because", then tell them too bad - Oracle best practice is to use 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ana Choto
Sent: Tuesday, August 09, 2005 8:53 AM

 . . .

My question is, if there is a problem by having tables analyzed with
dbms_stats and others with analyze compute.

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.


Other related posts: