MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Limitations
Posted by: Rick James
Date: September 18, 2009 11:11PM

I think the limitation is that it could not efficiently enforce the "unique" constraint of the PRIMARY KEY because the uniqueness would be spread across all the partitions.

Would you like to discuss why you want to partition; perhaps we can discover some workaround.

Options: ReplyQuote


Subject
Views
Written By
Posted
6267
September 17, 2009 07:50PM
Re: Partitioning Limitations
2741
September 18, 2009 11:11PM
2541
September 21, 2009 02:59AM
2689
September 22, 2009 08:28AM
2527
September 27, 2009 10:27PM
2578
September 27, 2009 10:47PM
2741
October 03, 2009 02:43AM
2746
October 03, 2009 06:03PM


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.