Chapter 36. Query Analysis

by Ray Rankins

IN THIS CHAPTER

  • Displaying Execution Plans in Query Analyzer

  • Query Analyzer Server Trace

  • Query Analyzer Client Statistics

  • SHOWPLAN_ALL and SHOWPLAN_TEXT

  • Statistics

  • Query Analysis with SQL Profiler

SQL Server's cost-based query optimizer typically does a good job of determining the best query plan to process a query. At times, however, you might be a little bit skeptical about the plan that the optimizer is generating 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 that the optimizer is generating, such as the following:

  • Is the optimizer using the indexes that you have defined, or is it performing table or index scans?

  • Are worktables ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.

Start your free trial