How to Tune SQL Joins in Oracle Database – Free Tutorial
Duration: 14 minutes

Teacher

Curriculum

Free

How do you tune SQL Joins? Start with the most important ingredient – the join order! It’s the closest thing to a silver bullet for tuning joins.

In this free tutorial by Oracle Certified Master DBA John Watson you will learn how to calculate the “filtered rows percentage”, what the optimal join order how to determine if the CBO has chosen the optimal join order. Last but not least, John will shed light on what to do if CBO does not choose the optimal join order!

No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.

0/5
- Lecture1.1
  
  Agenda
  
  0m
- Lecture1.2
  
  Lesson 1 – The Critical Decisions for Join Execution
  Preview
  
  2m
- Lecture1.3
  
  Lesson 2 – The Optimal Join Order
  
  2m
- Lecture1.4
  
  Lesson 3 – Demonstration; Determining if CBO got the Join Order Correct
  
  8m
- Lecture1.5
  
  Lesson 4 – What to do if CBO Fails You! (And other closing remarks)
  
  2m