A tuning job enables you to view the cost details of SQL statements on a registered data source and then select the best, or most efficient, array of execution path directives in order to make query execution faster, therefore improving the entire enterprise, overall.
A tuning job consists of a set of SQL statements and any analysis results you generate against a data source using tuning. The SQL statements and analysis results that compose a tuning job can be saved in a tuning file (.tun). This enables you to open a tuning job at a later time for inspection and analysis, to add, delete, or modify the SQL statements, or generate new execution statistics.
The following topics provide a high-level overview of the tuning process:
- Create a new tuning job
- Specify a data source
- Add SQL statements
- Run a tuning job
- Analyze tuning results
- Modify tuning results
For additional commands that fall outside the general tuning workflow, but may still be helpful, see Additional tuning commands.
For information on working with data sources such as adding and browsing them, see Working with data sources.