First page Back Continue Last page Graphics
Join Methods
Oracle9i CBO supports the following join methods:
- Nested Loops Join
- Outer Join
- Sort-Merge Join
- Hash Join
- Anti-Join
- Semi-Join
Notes:
A join operation combines two sources and returns one resulting row source. The join methods are discussed in detail throughout this lesson.