MySQL Forums
Forum List  »  Partitioning

Re: Partitions for already existing table
Posted by: Rick James
Date: July 30, 2011 04:18PM

You get an unpleasant choice --
Plan A: Have no UNIQUE keys on the PARTITIONed table. That leads to no UNIQUEness constraints.
Plan B: Put the partition key(s) into every UNIQUE key.

How many rows in your table? If it is not over a million, PARTITIONing is probably not worth doing.

Options: ReplyQuote

Written By
Re: Partitions for already existing table
July 30, 2011 04:18PM

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.