RE: Analyze vs. dbms_stats with Partitioning

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 1 Jun 2005 15:46:37 -0400
Message-ID: <96FB7D6574516C45922A76B354B684FD45A589@USHQEXVS.polanet.polaroid.com>

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_at_labor.state.ny.us]=20 Sent: Wednesday, June 01, 2005 3:21 PM
To: Hand, Michael T; oracle-l_at_freelists.org 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.

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

Received on Wed Jun 01 2005 - 15:51:40 CDT