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.
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:
- Introduction (including First Demonstration) (7:11)
- SubQuery Factoring (14:38)
- Star Transformations (15:55)
- Aggregations (8:16) (click on video below)
- Summary (3:31)
Date: Sep 12, 2012
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.