Tuning Oracle SQL – How to Get the Best Join Order | Using Extended Statistics (Default Statistics are Not Always Enough)

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.