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
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@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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
