Re: Auto stats gathering is not sufficient - what now?

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Thu, 10 Feb 2011 11:07:55 +0200

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2011