When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. One exchange operation.Exchange (clear) out of target bottom-up. 1)Exchange sub partitioning ALTER TABLE DEPARTMENT EXCHANGE SUBPARTITION SYS_SUBP7356 WITH TABLE TEMP_DEPARTMENT WITHOUT VALIDATION UPDATE GLOBAL INDEXES; The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. In MySQL 5.7, it is possible to exchange a table partition or subpartition with a table using ALTER TABLE pt EXCHANGE PARTITION p WITH TABLE nt. Index is partitioned independently of data. • Each index structure may reference any and all partitions. This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax.