There are three main steps to the SQL tuning process:
You may be lucky and know already the exact SQL causing the problem. If so, move straight on to the second step. Otherwise, click on the link above for help on finding the problem SQL.
Most performance problems are quite common and easy to fix. This section will describe some of these and how to spot them, and then go on to describe a more general analysis method.
Almost every performance problem has a solution; it's just that some are more complex than others. In order of increasing complexity and expense, such fixes include:
No links are provided here for fixes. Every problem is different, and the fixes are a logical progression of the analysis. Follow the link for Step 2 above to determine the problem and see the recommended fix. If this does not work, consult a more experienced SQL Tuner, the System Architect, or the DBA.