MySQL Forums
Forum List  »  Partitioning

Re: Why Unique Key Constraint?
Posted by: Rick James
Date: March 20, 2010 03:44PM

Without that restriction, enforcing a UNIQUE constraint would require looking in every partition to see if the key already exists. This would be unacceptably bad for performance.

Would you care to share your schema; we could discuss this further.

Options: ReplyQuote

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