MySQL Forums
Forum List  »  Partitioning

Index management in a partitioned table
Posted by: Rathi Rao
Date: September 29, 2016 12:14AM


I have a partitioned table. It has 2 partitions. The business requirement is such that I have to truncate partitionA and insert data into it and the other partition, parititionB, I have to just insert the data.

This is all working fine. What I need to understand is how do the indexes work?

1. So, when I truncate partitionA would all the entries in the index belonging to partitionA be erased?
2. After I truncate the partitionA would all enteries for the index related to partitionA be created again (during insert)?
3. Even thought the index statement does not require mentioning partitions, internally its managed as 2 indexes, am I right?
4. Will the index related to parititionB is updated/deleted/inserted as and when data is fed into it?

Thanks in advance

Options: ReplyQuote

Written By
Index management in a partitioned table
September 29, 2016 12:14AM

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.