Using partition-based scans on both tables in a join is fairly rare because of the high cost of repeatedly scanning the inner table. The optimizer may also choose:
A merge join.
The reformatting strategy, if reformatting is a cheaper alternative.
A partitioned-based scan plus a hash-based index scan, when a join returns rows from 20 or more data pages.
See Figure 24-7 for an illustration.