SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Tuning Oracle SQL - How to Get the Best Join Order

Oracle Consultants Available

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!

Dec 12 - SkillBuilders Oracle 11g PL/SQL Programming Workshop

This free tutorial is segmented into several separate lessons:

Listen to the Podcast for this Training
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)  
3. Using and Reverse Engineering Extended Statistics   (3:45)  

Date: Jan 13, 2014

View all videos now - Free Online Registration required

Here is a preview:

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