Page History

...

1. Ensure you have registered and selected a data source. For more information, see Register Data Sourcesdata sources and Specify a Data Sourcedata source.
2. Ensure you are connected to the database by double clicking the database name in the Data Source Explorer.
3. Click the tuning icon on the toolbar, or click File > New > Tuning Job.
4. On the Overview tab, specify the SQL you want to tune:
   • Modify the number of times to execute each statement in the Execute each generated case field at the top right of the tuner, as needed.
5. Click the execution button [ ] on the right side of the case generation field.
6. The tuning job runs, exacting and analyzing each statement and providing values in the appropriate columns.

To explicitly generate a case for a specific statement

1. Ensure you are connected to the database by double clicking the database name in the Data Source Explorer.
2. Click the Overview tab.
3. In the Generated Cases area, right-click in the Name field of a statement or transformation case and select Generate Cases from the context menu, or click the Overview Run Job icon. The specified case is generated.

To view the generated cases for a specific statement

1. In the Tuning Statements area, click the checkbox to the left of the tuning source statement name.
   A check mark appears in the checkbox and the cases displayed in the Generated Cases area are filtered to display only those cases related to the selected source statement.