O'Reilly logo

Microsoft® SQL Server 2005 Unleashed by John Kane, Tudor Trufinescu, Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

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 31. Query Analysis

IN THIS CHAPTER

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 that 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 or index scans? ...

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