RE: Estimate versus Compute

From: Kevin Lange <klange_at_ppoone.com>
Date: Mon, 25 Jul 2005 14:25:57 -0500
Message-ID: <ED1256BD4F253C44B1627B2D365A334F08766C7D@ppoone1.ppoone.com>

Not a bad thought, but, as I forgot to mention it, we are using 8.1.7.4 right now and I tried this with the result of DBMS_STATS.AUTO_SAMPLE_SIZE not being recognized.

Oh well, thanks anyway.

-----Original Message-----

From: sol beach [mailto:sol.beach_at_gmail.com] Sent: Monday, July 25, 2005 2:07 PM
To: Oracle-L_at_freelists.org
Subject: Re: Estimate versus Compute

Here is what I use:
 exec dbms_stats.gather_schema_stats( -

          ownname => USER,          - 
          estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 
          method_opt => 'FOR ALL INDEXED COLUMNS', - 
          granularity => 'ALL',  - 
          cascade => TRUE  - 
          );

I think it was at asktom.oracle.com where I read to use "AUTO_SAMPLE_SIZE"; which Oracle can vary on a per version basis
--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 25 2005 - 14:27:55 CDT