This hands-on course provides students with the skills necessary to tune SQL statements. Attention is paid to understanding Oracle architecture, rules based and cost based optimization. The following tuning tools are covered in detail: explain plan, TKPROF and autotrace. A detailed discussion of indexes is provided so that the proper index type is chosen for a given scenario.
|
Class Agenda:
- Introduction to SQL Tuning
- Architecture Overview
- SQL Statement Processing
- Tuning Tools
- Optimization
- Using Hints to influence the CBO
- Indexes
- SQL Performance Tips
- Join and Subquery Execution Plans
- PL/SQL Tuning
- Tuning Views
|
Prerequisites:
- Oracle SQL Fundamentals, Oracle PL/SQL Fundamentals
Audience:
- Oracle application developers
Course Benefits:
- Students will gain the ability to improve the performance of applications that depend heavily on access to an Oracle database by testing various SQL possibilities and choosing the most efficient option.
Materials Furnished:
Recommended Follow-on Courses:
- Oracle 9i Advanced PL/SQL
- Oracle 9i Advanced SQL
Course Length:
List Price: $1485 |
