Back

Oracle SQL Tuning Free Tutorial

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.

This free training is segmented into several separate lessons:

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

Date: Sep 12, 2012

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