Updated on 2025-05-29 GMT+08:00

Partition-wise Join

Partition-wise join is a partition-level parallel optimization technology. It divides a large join into smaller joins between a pair of partitions from the two joined tables when certain conditions are met. This improves the join query performance of partitioned tables by concurrent execution and reducing the amount of data communication.

Partition-wise join is applicable in SMP and non-SMP scenarios.