MySQL Forums
Forum List  »  Partitioning

Why Unique Key Constraint?
Posted by: Double Dragon
Date: March 14, 2010 04:59AM

I am new to partitioning and I was just going through the MySQL reference manual. It states that if a table has a UNIQUE key, the column used for partitioning must be part of that key. Now from the performance point of view, I can imagine why it could benefit MySQL for internal hashing but why has this been made mandatory?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Why Unique Key Constraint?
4773
March 14, 2010 04:59AM
2027
March 20, 2010 03:44PM


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.