New tuning jobs are created from scratch where you can specify the statements to be tuned from a variety of sources, or statements can be directly imported from existing profiling sessions on data sources currently registered in the environment.

To create a new tuning job

  • If you determined from a profiling session that a specific SQL statement should be tuned, in the Profile Session, right-click the statement and select Tune as follows:

OR

  • Select File > New > Tuning Job, or click the New Tuning Job icon on the Toolbar. SQL Tuner opens and you can proceed to set up the parameters of the new job.

Once you define the input of the tuning job, you can save the file with a .tun suffix via the Save As command. The job is added to the SQL Project Explorer and can be re- opened and re-run at any time once it is saved to the system.