This module is designed to give you an overview of the internal functions and tuning of Oracle SQL statements. Each of the subjects introduced in this module will be examined in much greater detail during the course.
Topics in this module include:

1. Oracle extensions to ANSI standard SQL
2. Basic SQL tuning tools
3. Using the EXPLAIN PLAN utility
4. The SQL optimizer modes
5. The rule-based SQL optimizer
6. The cost-based SQL optimizer
7. Tuning SQL with hints