This discussion will help you understand the methodology behind SQL Query Tuner's tuning functionality and how you can use it to optimize database performance. This discussion is comprised of the following topics:
• Introduction to SQL Query Tuner's Tuner
• SQL Tuning Methodology
• SQL Tuner Overview
• What's happening on the databases?
• Tuning Example
• The Database is Hanging or the Application has Problems
• The Database Caused the Problem
• The Machine Caused the Problem
• Finding and Tuning Problem SQL