MySQL Forums
Forum List  »  Partitioning

Re: Partitioning Problem
Posted by: Rick James
Date: April 11, 2010 10:46PM

Why do you want to partition that way?

I think the reason that it is disallowing what you are trying is... To enforce UNIQUEness (of a PRIMARY KEY or UNIQUE key), it would have to check every partition on every INSERT. If you were partitioning on the emp_id, then it could do the check without hitting every partition.

Do you have a million employees? Are you dropping old employees? PARTITIONing a small tables doesn't buy much.

Options: ReplyQuote

Written By
April 09, 2010 07:07AM
Re: Partitioning Problem
April 11, 2010 10:46PM

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.