SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

CHAPTER 16

Managing Indexes

by Jason Brimhall

Indexes assist with query processing by speeding up access to the data stored in tables and views. Indexes allow for ordered access to data based on an ordering of data rows. These rows are ordered based upon the values stored in certain columns. These columns comprise the index key columns, and their values (for any given row) are a row’s index key.

This chapter contains recipes for creating, altering, and dropping different types of indexes. I demonstrate how indexes can be created, including the syntax for index options, support for partition schemes, the INCLUDE command, page and row lock disabling, ...