How to Tune SQL Joins in Oracle Database

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!

This free training is segmented into several separate lessons:

  1. Lesson 1 – The Critical Decisions for Join Execution (1:53) (click on video below)
  2. Lesson 2 – The Optimal Join Order (1:52)
  3. Lesson 3 – Demonstration; Determining if CBO got the Join Order Correct (8:12)
  4. Lesson 4 – What to do if CBO Fails You! (And other closing remarks) (1:54)

Date: Jan 20, 2016


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×