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:
- Join Order: The Closest Thing to a Silver Bullet for Oracle SQL Tuning (1:58)
- Using Extended Statistics (Default Statistics are Not Always Enough) (8:45)
- Using and Reverse Engineering Extended Statistics (3:45) (click on video below)
Date: Jan 13, 2014
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.