Search notes:
Oracle SQL Plan operation SORT (PARTITION JOIN)
See also
Paritioned outer joins
Other plan operators
such as
MERGE JOIN PARTITION OUTER
Index