This discussion will help you understand the methodology behind DB Optimizer's tuning functionality and how you can use it to optimize database performance. This discussion is comprised of the following topics:
- Introduction to DB Optimizer tuner
- SQL tuning methodology
- SQL tuner overview
- What's happening on the databases?
- Tuning example
- Finding and tuning problem SQL