Detecting Problems in Plans
If you’ve read Chapter 3, you should have a basic understanding of how to read query plans and understand most of the basic operators. Now, we’ll discuss some of the problems and pitfalls that you may encounter. Keep in mind that there is no one-size-fits-all approach to diagnosing problems with query plans. Queries do not perform as expected for many different reasons. Each situation is unique, and there are few if any absolute rights or wrongs. An operator may be the best choice in one scenario and a poor choice in another. Moreover, before we can evaluate whether a query plan is good or bad, we also need to understand what our goal is or what the problem is that we are trying to solve. For example, we might be ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
