Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Each tuning source statement is listed by Name, Schema, Text, Tables and Views. For SQL Server and Sybase platforms, there is also a Catalog column. Additionally, each statement will have Time and Analysis values that approximate how efficiently they execute on the specified data source.

...

  1. Ensure you have registered and selected a data source. For more information, see Register Data Sourcesdata sources and Specify a Data 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.

...