Chapter 33. Tuning Queries Using Hints and Plan Guides
In this chapter, we build on the performance tuning methodology and concepts presented in earlier chapters. We will take a look at tuning queries in somewhat extraordinary conditions where the common performance tuning methods, such as tuning system resources, creating the optimal indexes, and ensuring accurate table statistics, do not resolve the problem and a more brute force approach of specifying explicative directives to the query, called hints, is required.
We start by taking a detailed look at the three different types of hints: join hints, query hints, and table hints, along with examples of how to use ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
