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
コメント