RE: Analyze vs. dbms_stats with Partitioning

  • From: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 1 Jun 2005 14:58:46 -0400

 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?


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

Mike H

P.S. Am reading several articles by ANanda and JLewis on the subject.

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.


Other related posts: