MySQL Forums :: Partitioning :: Index management in a partitioned table


Advanced Search

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

Hi,

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
Rathi

Options: ReplyQuote


Subject Views Written By Posted
Index management in a partitioned table 434 Rathi Rao 09/29/2016 12:14AM
Re: Index management in a partitioned table 300 Rick James 10/02/2016 12:40PM
Re: Index management in a partitioned table 233 Rathi Rao 10/03/2016 11:59PM


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.