Tuning SQL workflow

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

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.

Related topic

Tuning-SQL



 

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