What is an index?

Indexes help speed up searching in a database. If there is no index on a column in the WHERE clause then the SQL Server has to skim through the entire table and check each and every row to find matches, which may result in slow operations in large data.

Indexes are used to find all rows matching with some columns and then to skim through only those subsets of the data to find the matches.