Chapter 36. Query Analysis

SQL Server’s cost-based Query Optimizer typically does a good job of determining the best query plan for processing a query. At times, however, you might be a little bit skeptical about the plan the Query Optimizer generates or want to understand why it is choosing a specific plan. At the least, you will want to know the specifics about the query plans the Query Optimizer is generating, such as the following:

• Is the Query Optimizer using the indexes you have defined, or is it performing table ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.