Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

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.

    QuickCourseArrow.png

    For more information, view the Quick Course Workbench for DB2 - Analyzing SQL Performance.

Related topic

Tuning-SQL



 

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