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.