RE: Analyze vs. dbms_stats with Partitioning
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <HANDM@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 15:21:01 -0400
Mike,
One big advantage is that dbms_stats can gather stats in parallel.
Analyze cannot.
But a bigger reason is that analyze goes away in 10g ( if I remember
correctly).
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hand, Michael T
Sent: Wednesday, June 01, 2005 2:59 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Analyze vs. dbms_stats with Partitioning
Ok, first misconception reached. I thought analyze didn't handle
partitioned segments but a quick RTFM and trace shows normal range
partition pruning with Analyze generated stats. So is there an
advantage of dbms_stats here? Or is the advantage the addition features
dbms_stats brings withit?
Mike
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hand, Michael T
Sent: Wednesday, June 01, 2005 1:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Analyze vs. dbms_stats with Partitioning
I am in the initial stages of experimenting with Partitioning, and
therefore also moving from analyze to dbms_stats. Does one have to
delete the analyze-created stats before generating the dbms_stats-based
ones, or is that a Oracle-legend I heard/read in the distant past? Is
there anyway to determine which means was used to generate the stats
after the fact?
This is for V9.2.0.5 on Tru64.
Thanks,
Mike H
P.S. Am reading several articles by ANanda and JLewis on the subject.
--=3D20
This transmission is intended only for use by the addressee(s) named
herein=3D
and may contain information that is proprietary, confidential and/or
legal=3D
ly privileged. If you are not the intended recipient, you are hereby
notifi=3D
ed that any disclosure, copying, distribution, or use of the information
co=3D
ntained herein (including any reliance thereon) is STRICTLY PROHIBITED.
If =3D
you received this transmission in error, please immediately contact the
sen=3D
der and destroy the material in its entirety, whether in electronic or
hard=3D
copy format. Thank you.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
