X hits on this document

115 views

0 shares

0 downloads

0 comments

40 / 48

674

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.

Document info
Document views115
Page views115
Page last viewedFri Dec 09 08:23:09 UTC 2016
Pages48
Paragraphs987
Words15822

Comments