MySQL Forums
Forum List  »  Partitioning

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

MySQL Server version 5.5.32
TYPE = MyISAM

help please,
As in my case, to build an index on for each partition (subpartition),
not on single table.

on table 3 billion rows!
If I add new rows on partitioned table, as will be rebuild index?

I want to add new partition (subpartition) and create index on new partition later.

please show me code, how to do it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Create index on parttion table (manually and dynamically)
2020
July 07, 2013 12:20AM


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.