Sort merge join

From Oracle FAQ

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

Also see

• Cluster join
• Hash join
• Nested loops join

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	#