Page History
...
- Ensure you have registered and selected a data source. For more information, see Register Data Sourcesdata sources and Specify a Data Sourcedata source.
- Ensure you are connected to the database by double clicking the database name in the Data Source Explorer.
- Click the tuning icon on the toolbar, or click File > New > Tuning Job.
- 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.
- Click the execution button [ ] on the right side of the case generation field.
- 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
- Ensure you are connected to the database by double clicking the database name in the Data Source Explorer.
- Click the Overview tab.
- 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
- 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.