MySQL Forums :: Partitioning :: Range partition and unique key


Advanced Search

Re: Range partition and unique key
Posted by: Rick James ()
Date: September 25, 2014 09:59AM

First, explain why you want to PARTITION the table. There is _no_ inherent benefit in adding PARTITIONs, except for a few queries that could take advantage of it.

The answer to that may lead to an un-obvious way to achieve your required UNIQUEness constraint.

Also, please explain why you are using MyISAM, not InnoDB.

Options: ReplyQuote


Subject Views Written By Posted
Range partition and unique key 1871 Pierrick VODOZ 09/24/2014 08:42AM
Re: Range partition and unique key 958 Rick James 09/25/2014 09:59AM
Re: Range partition and unique key 991 Pierrick VODOZ 09/26/2014 03:40AM
Re: Range partition and unique key 1036 Rick James 09/27/2014 08:25AM


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.