Tuning Oracle SQL – How to Get the Best Join Order

Learn how to get the best (i.e. most efficient) join order in Oracle SQL statements.  Often this requires collecting extended statistics.  In this free tutorial, learn what Extended Statistics are and how they can be used to provide the closest thing to a “silver bullet” in Oracle SQL tuning:  the correct join order!

This free tutorial is segmented into several separate lessons:

  1. Join Order: The Closest Thing to a Silver Bullet for Oracle SQL Tuning   (1:58)
  2. Using Extended Statistics (Default Statistics are Not Always Enough)   (8:45) (click on video below)
  3. Using and Reverse Engineering Extended Statistics   (3:45)

Date: Jan 13, 2014


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!

 

×