SkillBuilders Welcome  |  Log in
All Oracle Tutorials

Oracle SQL Tuning Free Tutorial

Oracle Consultants Available

There are often several ways to get the same answer from your Oracle Database.  But which version of the equivalent SQL query is faster? We need to learn how to tune SQL statements that produce equivalent results. 

Listen and watch as Oracle Master John Watson demonstrates why not all equivalent SQL statements are created equal. 
John demonstrates how SQL statements that produce equivalent result sets can have radically different response times, why this happens and common solutions.

In this free video tutorial, listen and watch as Oracle Master John Watson demonstrates why equivalent SQL statements are not all created equal when it comes to performance. 

John demonstrates how SQL statements that produce equivalent result sets can have radically different response times, why this happens and common tuning solutions.

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

This free training is segmented into several separate lessons:

1. Introduction (including First Demonstration)   (7:11)   (click to read the Transcript)
2. SubQuery Factoring   (14:38)  
3. Star Transformations   (15:55)  
4. Aggregations   (8:16)  
5. Summary   (3:31)  

Date: Sep 12, 2012

View all videos now - Free Online Registration required

Here is a preview:

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

Want more help?  Try:

Training: Oracle SQL Tuning for Developers and DBA's

Consulting: Short or long term assignments;  let us help you with your tuning issue!

Not Convinced?  Try our Free Performance Analysis