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

Ana,

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 dbms_stats.

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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.

--
http://www.freelists.org/webpage/oracle-l