CHAPTER 28 ■ PERFORMANCE TUNING
Figure 28-23. Apply Recommendations dialog box
This launches the Applying Recommendations status dialog (see Figure 28-24). When the process is finished, click the Close button.
Figure 28-24. Applying Recommendations status dialog box
At this point, you can re-test the original recipe query and view any impact on the execution plan. In this case, as you can see in Figure 28-25, two tables (instead of just the original one) are now using Index Seek operations.
Figure 28-25. Post Recommendation execution plan
Testing the query duration, you can decide if the time saved by creating the index is worth the additional disk and database modification overhead of keeping the newly recommended indexes.