Re: dbms_stats.gather_table_stats

From: John Kanagaraj <>
Date: Sun, 7 Sep 2008 22:15:07 -0700
Message-ID: <>

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 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 <>< (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 **
Received on Mon Sep 08 2008 - 00:15:07 CDT

Original text of this message