Index Design Guidelines

SQL Server indexes are mostly transparent to end users and T-SQL developers and are typically not specified in queries unless you use table hints to force the Query Optimizer to use a particular index. (Although forcing indexes is generally not advised, using Query Optimizer table hints is covered in more detail in Chapter 40, “SQL Server Database Engine Tuning Adviser.”) Normally, based on the index key histogram or density values, the SQL Server cost-based Query Optimizer automatically chooses the index that is least expensive from an I/O standpoint.

Chapter 34 goes into greater detail on how the Query Optimizer estimates I/O and determines the most efficient query plan. In the meantime, the following are some of the ...

Get Microsoft SQL Server 2014 Unleashed 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.