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