Re: Estimate versus Compute

From: sol beach <sol.beach_at_gmail.com>
Date: Mon, 25 Jul 2005 12:07:24 -0700
Message-ID: <40a16b3605072512074b30a558@mail.gmail.com>

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

Received on Mon Jul 25 2005 - 14:09:30 CDT