Wednesday, March 17, 2010

managing statistics on partitions

The best methods for managing statistics in general on Oracle is an area that has yet to well ironed out but when it comes to partitions is all the more challenging. Doug Burns is putting together a set of blog post attempting to iron out some of the issue :
  • Part 1 – In which we see a simple example and do a default stats collection
  • Part 2 – In which we consider Global Stats
  • Part 3 – In which subpartitions and aggregation cause problems
  • Part 4 – In which our hero fights his way through stats aggregation woes
  • Part 5 - In which we encounter a partition exchange
Nice aggregated listing via Jonathan Lewis

No comments:

Post a Comment