Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
6. Techniques to Improve Query Performance
After you have designed your database and application, you typically want to make sure that it can deliver the performance that your application users demand. This chapter covers what you can do to find performance problems in your database and how to solve the problems you uncover. Microsoft SQL Server 2008 is an extremely capable and efficient database engine, but it still requires you to do some performance tuning if you have a very large database, complicated queries, a high number of queries being served, or a combination of these factors.
Exam objectives in this chapter:
-
Create and alter indexes.
-
Implement partitioning solutions.
-
Control execution plans.
-
Capture execution plans.
