General steps for tuning SQL statements

In most cases, to tune an SQL statement, you can follow these steps.

Before you begin

Procedure

  1. 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.
  2. Run the analysis tools and single-query advisors on the SQL statement, and then view the results. You can also generate reports.
  3. 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.

Feedback