Tuning SQL workflow

The workflow for tuning a SQL statement typically includes the following steps:

Related topics

Tuning SQL

To tune a SQL statement

  1. Select a SQL statement to be used as the baseline statement (Selecting a statement for SQL Analysis).
  2. Perform an Explain on the statement (Explaining SQL statements).
  3. Create a What-If scenario based on the baseline statement (Creating a What-If scenario).
  4. Compare the cost of the statements (Comparing statements).
  5. Create a new What-If scenario.

  6. Continue the process until you have optimized the statement.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*