12.3. Manage Special Index Operations
As always, there are some exceptions to the rules. While most indexing strategies provide support for standard optimizer behavior, there are always special cases and they can have both positive and negative impacts on performance. Being aware of these special cases allows you to take advantage of performance opportunities and avoid potential pitfalls.
Figure 12.10. The Reports tab
12.3.1. Cover a Query
Covering is the process of retrieving all necessary data from an index instead of going to the data page. This behavior is specifically related to nonclustered indexes. The concept is simple: Nonclustered ...
Get SQL Server® 2008 Administration: Instant Reference 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.
