1
An index helps SQL Server retrieve data from rows quickly. Indexes work like the table of contents at the beginning of books, allowing you to look up the page a topic is on fast. Without indexes, SQL Server has to scan all the rows in a table to find a record.