May 2011
Intermediate to advanced
352 pages
11h 27m
English
Indexes are used to improve the performance of data retrieval, to order data, and sometimes to enforce uniqueness. It’s the first of these uses, improving data retrieval, that I’ll focus on in this chapter. We’ll use the DMVs to identify indexes that may be suboptimal or unnecessary, as well as indexes the optimizer would like to use but are missing. All these aspects of index optimality can affect the performance of your SQL queries, sometimes significantly. I’ll provide discussions within each code snippet on index optimization. ...