In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.
1. Introduction
2. Introduction to SQL Tuning
3. Using Application Tracing Tools
4. Understanding Basic Tuning Techniques
5. Optimizer Fundamentals
6. Generating and Displaying Execution Plans
7. Interpreting Execution Plans and Enhancements
8. Optimizer Join Operations
9. Other Optimizer Operators
10. Introduction to Optimizer Statistics Concepts
11. Using Bind Variables
Workshops