Re: Auto stats gathering is not sufficient - what now?
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 10 Feb 2011 11:07:55 +0200
Message-id: <4D53AAEB.5020105_at_inter.net.il>
Partitioned by week?
Date: Thu, 10 Feb 2011 11:07:55 +0200
Message-id: <4D53AAEB.5020105_at_inter.net.il>
Partitioned by week?
And compute statistics each night only on the current partition?
Yechiel
On 09/02/2011 21:50, TJ Kiernan wrote:
>
> 10.2.0.3 on 32-bit Windows 2003 R2
>
> I have a reporting table that is too large to grow by 10% very often -
> 66 million records growing by 250k per week
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 10 2011 - 03:07:55 CST