MySQL Forums
Forum List  »  Partitioning

Re: Create index on parttion table (manually and dynamically)
Posted by: Vladimir Pivovar
Date: July 07, 2013 10:57AM

MySQL Forums :: Partitioning :: Rebuilding Index on One Partition


ALTER TABLE table_name DISABLE KEYS;
LOAD DATA INFILE ... INTO table_name ...
ALTER TABLE table_name REBUILD PARTITION partition_name
ALTER TABLE table_name ENABLE KEYS;


The entire table will not be rebuilt?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Create index on parttion table (manually and dynamically)
1779
July 07, 2013 10:57AM


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.