Merging and Splitting Partitions

Over time, a partition’s data distribution may become skewed, or the manner in which the data was originally partitioned may not suit current business requirements. Use alter table to merge, split, or move partitions to redistribute the data and revive the performance benefits of using partitions.

For example: