What Join Types or Join Methods Does Oracle Have?

Do you need to tune a SQL Statement in an Oracle Database? Do you suspect the Optimizer has chosen the wrong join type? Well, it turns out the Oracle Optimizer has just three join methods to choose from when it comes to deciding how to join data from two data producing operators in an execution plan. In this video, we examine when each join method is considered and also look at the additional five join types that are possible in Oracle, where these methods and types are used.
TOC
What are Nested Loops joins 0:27
What is a Hash Join 0:58
What is a Sort Merge Join 1:38
What is an Inner Join 2:25
What is an Outer Join 2:40
What is a Cartesian Join 3:32
What is a Semi-Join 4:42
What is an Anti-Join 4:42
SQL Tuning Example 1 5:20
Why the Nested Loops operator appears twice in a plan 06:03
SQL Tuning Example 2 6:50
What is Table elimination 7:17
What to do if you get the wrong join type 9:08
What to do if you get a hash join instead of a nested loop 9:53
Adaptive Joins in 12c 10:20

[@humayunhimu6045]

Thanks Maria! What a learning!! Awesome!

[@ade05fr]

Thanks. I discover you videos they are great and help me to understand very easily the concepts.

[@rahulmittal116]

Nice Video Maria..
Can you please create a video on how to use Adaptive plan?

[@syedmohsin677]

Nice Explanation 😊

[@lucasweber140]

Excelent video

[@fancystacy]

It's a very good explanation.

[@SQLMaria]

Glad you liked it

[@jamsher731]

Hi Maria, How we can confirm if optimizer has chosen Adaptive Join

[@babakvahidnia206]

Thanks . Very informative 🙏🙏

[@marcinbadtke]

Thank you