Overview - Describe the basic steps in processing SQL statements
- Describe the causes of performance problems
- Understand where SQL tuning fits in an overall tuning methodology
- Describe Automatic SQL Tuning
- Use the diagnostic tools to gather information about SQL statement processing
- Understand Optimizer behavior
- Influence the optimizer behavior
- Influence the physical data model so as to avoid performance problems
Pre-Requisites
Next Course Dates
Dates available on request. Please contact us
More Information
- Technical Consultant
- Forms Developer
- Java Developer
- PL/SQL Developer
- Reports Developer
- Business Intelligence Developer
- Describe the basic steps in processing SQL statements
- Describe the causes of performance problems
- Understand where SQL tuning fits in an overall tuning methodology
- Describe Automatic SQL Tuning
- Use the diagnostic tools to gather information about SQL statement processing
- Understand Optimizer behavior
- Influence the optimizer behavior
- Influence the physical data model so as to avoid performance problems
- Database Architecture overview
- Following a Tuning Methodology
- Designing Applications for performance
- Introducing the optimizer
- Optimizer Operations
- Displaying Execution plans
- Gathering Statistics
- Application Tracing
- Identifying High Load SQL
- Automatic SQL Tuning
- Introduction to Indexes
- Advanced Indexes
- Optimizer Hints and Plan Stability
- Materialized Views and Temporary Tables