The optimizer considers parallel merge joins when the configuration parameter enable merge joins is set to 1 and the table accesses more than 20 data pages from the outer table in the merge join.
Figure 25-5: A parallel right-merge join
