MySQL Forums
Forum List  »  Partitioning

insert to a partitioned table with a unique key
Posted by: Raghupradeep Aravindakshan
Date: March 15, 2017 06:50AM

Hello,

I have a table range partitioned by time. This table is going to be huge and will hold millions of records. I have to add a unique key to this table.

My doubt is does MySQL will do a entire table check before doing an insert or will it select the partition where the data has to be inserted based on time and check for uniqueness only in that partition.

My unique key contains the partition column as well.

With Regards
Raghupradeep

Options: ReplyQuote


Subject
Views
Written By
Posted
insert to a partitioned table with a unique key
83
March 15, 2017 06:50AM


Sorry, only registered users may post in this forum.

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.