Oracle Database Review
Gathering Statistics and Partitions


Valuable Features:

Partitions and the various methods available

Room for Improvement:

Statistics for the Partitions Lack of support for Oracle Text Indexing with all the various partitioning options

Other Advice:

Gathering Statistics is important for query plans. However, in a partitioned table environment, it would seem that each partition of a table would have about the same number of records especially when the major key is something like transaction date. So why not have an option to copy the statistics from a "standard partition" when a new partition is added? OR allow for parameters in the table partition metadata to store and update the values that have to be copied for the statistics. The partition is not fully loaded until the end of the "transaction day" and maybe the auto-statistics gathering processes can then make the updates to the finer points.Update:Gathering Statistics on Partitioned Tables using the INCREMENTAL = TRUE setting for the table keeps the statistics gathering humming nicely. A bit of a "to do" for the first time though. Also need to be aware that some disk space will be used to store statistics which can be referenced for the next run of gathering statistics (augmenting?)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 visitors found this review helpful

Add a Comment

Guest
Why do you like it?

Sign Up with Email