Sort merge join

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

A sort merge join is a join optimization method where two tables are sorted and then joined.

Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #