In most cases, to tune an SQL statement, you can follow
these steps.
Procedure
- Capture the SQL statement that you want to tune.
To capture the SQL statement means to specify the
statement that you want to tune. You can capture a statement from
a large number of locations. You can even type or paste a statement
directly into the tuning interface, which is called the workflow
assistant for query tuning.
- Run the analysis tools and single-query advisors on the
SQL statement, and then view the results. You can also generate reports.
- Tune the statement according to what you learn from the
analysis tools and reports and according to the advice that you receive
from the advisors.