SQL Server Indexes Part 1

The fifteenth part of the SQL Server Programming Fundamentals tutorial describes indexes. Indexes provide a lookup facility for a table, allowing rows to be found more quickly and without the need to scan the data in every row when querying a table. This article describes the purpose of indexes in a SQL Server database and some of the types of index that are supported by SQL Server 2005.