What Join Types or Join Methods Does Oracle Have?

Video Description

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