Chapter 15. Implementing Indexes and Statistics

Exam objectives in this chapter:

  • Create Database Objects

    • Create and alter views (simple statements).

  • Troubleshoot & Optimize

    • Optimize queries.

In Chapter 14, you learned about the tools that help you find performance problems. Indexes are mentioned in that chapter many times. This is not a coincidence. Proper indexing is necessary for good performance of your databases. In order to create appropriate indexes, you need to understand how Microsoft SQL Server stores data in tables and indexes, and how it then accesses this data. You learn about this in the longest lesson in this chapter, Lesson 1: Implementing Indexes.

No indexes can help you if you write inefficient queries. In Lesson 2: Using Search Arguments ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.