CHAPTER 28 ■ PERFORMANCE TUNING
Clicking the Tuning Options tab shows more options used to evaluate the workload (see Figure 28-19). Using options on this screen, you can set the maximum amount of time the tool can take to evaluate a workload. You can also specify which physical design structures can be recom- mended (in this example, you’ll be keeping the default of indexes), whether or not partitioning strategy recommendations are given, and whether or not all existing objects (indexes, indexed views) should be kept in the database.
Figure 28-19. Tuning Options tab
To begin analysis, go to the Actions menu and select Start Analysis. This opens up a new Progress screen (see Figure 28-20).
Figure 28-20. Progress tab
Once finished, two more tabs appear: the Recommendations tab and the Reports tab. The Rec- ommendations tab contains a list of recommendations generated to improve the performance of the query. Notice at the top of the screen in Figure 28-21 that the estimated improvement of the query is 22%. The Database Engine Tuning Advisor has recommended the creation of three new indexes which are listed in the Index Recommendations section. It is here that you can see which tables the indexes are to be added to, which columns will be indexed, and the index size in KB.