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.
Subject
Views
Written By
Posted
2977
September 24, 2014 08:42AM
Re: Range partition and unique key
1615
September 25, 2014 09:59AM
1657
September 26, 2014 03:40AM
1661
September 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.