RE: Analyze vs. dbms_stats with Partitioning
- From: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 15:46:37 -0400
Thanks Tom,
Also the export and import of statistics isn't too shabby. I thought
there might be problems with the way Analyze collect stats for non-range
partitioned segments, but I guess I'm wrong there (unless I can prove
otherwise ;) ).
Mike
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]=20
Sent: Wednesday, June 01, 2005 3:21 PM
To: Hand, Michael T; oracle-l@xxxxxxxxxxxxx
Subject: RE: Analyze vs. dbms_stats with Partitioning
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
--=20
This transmission is intended only for use by the addressee(s) named herein=
and may contain information that is proprietary, confidential and/or legal=
ly privileged. If you are not the intended recipient, you are hereby notifi=
ed that any disclosure, copying, distribution, or use of the information co=
ntained herein (including any reliance thereon) is STRICTLY PROHIBITED. If =
you received this transmission in error, please immediately contact the sen=
der and destroy the material in its entirety, whether in electronic or hard=
copy format. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
