Re: Dropping partition will affect index?
Posted by:
Rick James
Date: November 18, 2014 09:32AM
DROP PARTITION is much faster than DELETEing. Each PARTITION is (until 5.7.xx) essentially a separate table, complete with a subset of the data plus index(es) specific to that partition. So the DROP PARTITION will have zero effect on the remaining PARTITIONs.
If your table is a sliding timeslice, then read this about how to do the DROP and REORGANIZE to slide forward in time:
http://mysql.rjweb.org/doc.php/partitionmaint
I am surprised that you are not complaining about the performance of your DELETE option. With 10s of millions (crores) of records, each partition must be pretty big and the DELETE must be quite invasive.
Subject
Written By
Posted
November 17, 2014 07:42AM
Re: Dropping partition will affect index?
November 18, 2014 09:32AM
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.