Re: statistics on partitioned tables

From: onedbguru <onedbguru_at_yahoo.com>
Date: Thu, 10 Feb 2011 17:22:57 -0800 (PST)
Message-ID: <6a74312e-ed79-40e5-a89c-fbb93b32ed1d_at_f18g2000yqd.googlegroups.com>

On Feb 9, 1:20 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Chris wrote ...
>
> > oracle 10.2.0.4 enterprise  windows 2003 service pack 2
>
> > 1)       Code we use is driven by concept of list of stale objects at
> > table level
>
> > eg dbms_stats.gather_schema_stats  ( ....options list stale etc )
>
> > 2)       Is there scope for listing staleness at partition level
>
> >        Ie if partition 1 goes stale or partition 2 goes stale refresh
> > stats for partition and possibly table
>
> Try some google searches with words like "oracle statistics management
> partitioned tables" and you get hits like these ...
>
> http://blogs.oracle.com/optimizer/2009/02/maintaining_statistics_on_l...
>
> http://oracledoug.com/serendipity/index.php?/archives/1562-Statistics...

I have found that if a partition has NO stats, the performance can be very slow, but just adding ANY stats - even a zero (0) would make it perform. Each partition was fairly large. Received on Thu Feb 10 2011 - 19:22:57 CST