Overview

Convert existing large non-partition tables to partitioned tables to improve query performance (Partition Pruning) and maximize data management efficiency.

This article provides an example of converting a non-partitioned table into a partitioned table.

Method

Core Conversion Method: EXCHANGE PARTITION

This method moves large volumes of data instantly by swapping only metadata pointers without directly copying the data. It is highly recommended as it minimizes service downtime to an extreme degree.

Example Script Content

Please refer to the attached document.