Re: dbms_stats.gather_table_stats
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Sun, 7 Sep 2008 22:15:07 -0700
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 **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
