Re: copy of SAP COPA
It makes sense if the majority of your queries for reporting include period so that the optimizer can take advantage of partition pruning. If this is the case, then, yes, it should improve performance. You should verify that the optimizer is able to do partition pruning by using explain partition with a set of your typical reporting queries against the table.
If you never delete rows, but data from older periods becomes less relevant over time, then you should consider creating larger partitions for older periods (say, quarterly or yearly), assuming you are using range partitions - this will help with the number of partitions needed over time.
I don't believe that MySQL currently processes partitions in parallel when it's scanning for matches in multiple partitions, but I'm not positive.
Subject
Views
Written By
Posted
6585
March 24, 2008 02:06AM
Re: copy of SAP COPA
2673
March 24, 2008 07:42AM
2846
March 24, 2008 10:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.