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?


Options: ReplyQuote

Written By
Why Unique Key Constraint?
March 14, 2010 04:59AM
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.