MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Create index on partition table (manually and dynamically)
9731
Vladimir Pivovar
July 05, 2013 11:26PM
Re: Create index on parttion table (manually and dynamically)
3091
Rick James
July 06, 2013 10:52PM
Re: Create index on parttion table (manually and dynamically)
2779
Vladimir Pivovar
July 07, 2013 12:20AM
Re: Create index on parttion table (manually and dynamically)
2404
Vladimir Pivovar
July 07, 2013 10:57AM
Re: Create index on parttion table (manually and dynamically)
2659
Rick James
July 08, 2013 09:46AM
Re: Create index on partition table (manually and dynamically)
3039
Vladimir Pivovar
July 10, 2013 02:23PM


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.