Who should attend
- Developers
- Technical consultants
Course Objectives
- Identify problem SQL statements
- Modify a SQL statement to perform at its best
- Trace an application
- Understand how the Query Optimizer makes decisions about how to access data
- Interpret execution plans
- Use optimizer hints effectively
- Generate a load test
Product Description
- Architecture, SQL Tuning, and Optimization
- Database Architecture and SQL Tuning
- SQL Processing and the Optimizer
- Indexes, Access Paths, and Join Operations
- Table Scans, Indexes, Access Paths, and Joins
- Execution Plans and Star Transformations
- Interpreting Execution Plans
- Understanding Star Transformation
- Optimizer Statistics, Hints, and Cursor Sharing
- Optimizer Statistics
- Bind Variables, Cursor Sharing, and Optimizer Hints
- Application Tracing and Automatic SQL Tuning
- Application Tracing, Trace Files, and the tkprof Utility
- Automatic SQL Tuning