The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers. --------------------------------------------------------------------------- | Id | Operation | Name | Pstart| Pstop | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | | 1 | PX...