Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance impacts from uneven subpartitions

693248Apr 1 2009 — edited Apr 1 2009
I am currently working on a project with a large amount of metric data in a table that is partitioned by week, and then subpartitioned by one of 26 different machine types. For the most part, we get the same amount of data each week, so the partitions are about even in size. The subpartitions, on the other hand, have vastly different sizes (hundreds of rows compared to 10's of millions of rows), and in most cases, queries span the subpartitions.

Would these subpartitions degrade my performance when querying using multiple subpartitions? If so, is there a best practice for how evenly distributed data needs to be in order to get benefit out of subpartions?

Thanks,
Jon
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2009
Added on Apr 1 2009
5 comments
511 views