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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
