Tuning SQL
You can create one or more What-If statements and use them to progressively tune a selected baseline statement.
By default, BMC Workbench for DB2 honors the DB2 privileges to generate Explain plans. To configure BMC Workbench to allow Explain to acquire SYSADM authority for executing Explains, see information about the authexpl option in Configuring security for BMC Workbench in the Common DB2 documents space.
This section provides more information about the following topics:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*