O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17. Understanding Further Optimization Aspects

Exam objectives in this chapter:

  • Troubleshoot & Optimize

    • Optimize queries.

In Chapter 15, you learned internals about indexes and statistics in Microsoft SQL Server. In Chapter 14, you learned about the tools that help you analyze how a query was executed. In this chapter, you learn how SQL Server finds the data your query requests. SQL Server has different access methods for data retrieval. In addition, SQL Server implements different join algorithms. You learn about those and their strengths and weaknesses in this chapter.

SQL Server can reuse a query plan, even if the subsequent query is not the same. For example, the subsequent query can change a value for a search condition in the WHERE clause ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required