T-SQL » Indexes
Indexes are used in SQL Server to improve the time it takes for a particular query to locate the rows needed to satisfy the query criteria.
An index is a database object that provides fast access to data in the rows of a table, based on key values. They also enforce the uniqueness of the rows of a table.
