MySQL Forums
Forum List  »  Partitioning

Maintaining indexes with exchange partition
Posted by: Andrew Edwards
Date: June 25, 2019 05:04AM

We have a requirement to have a table partitioned by month to allow us to use exchange partition to swap in updated partitions on a regular basis. I want to understand how indexes are maintained on other columns in this scenario. When exchange partition is ran it will swap in the new data. I believe this is a simple file system operation of moving the new data in. How and when is the indexes updated? Or does it just retain the index data from the source table?

Options: ReplyQuote


Subject
Views
Written By
Posted
Maintaining indexes with exchange partition
1302
June 25, 2019 05:04AM


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.