Re: dbms_stats.gather_table_stats

Hi Gene,

In addition, keep in mind that gathering *just* partition level stats leads to estimation of column stats, and this can potentially change plans under certain circumstances.

>> Hi everybody:
>>
>> I am running oracle 10.2.0.1. Once a week we have a analyze process run to
>> gather stats on all the
>> tables in the schema via commands like this one exec
>> dbms_stats.gather_table_stats( 'schema', 'table', null, 25,
>> degree=>8, cascade=>true );
>

-- 
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l