MySQL Forums
Forum List  »  Partitioning

Re: No other way than delete primary key to create partitions by single datetime columns?
Posted by: Rick James
Date: August 24, 2015 12:36PM

An INDEX is unlikely to be "more powerful after the table is partitioned". A tiny advantage is that the BTree containing the index might be one level shallower. However, the pruning to pick the partition cost something -- probably as much as the BTree saves!

My blog contains the only 4 use cases I have found where PARTITIONing improves performance:
http://mysql.rjweb.org/doc.php/partitionmaint

Options: ReplyQuote




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.