Increasing performance by covering index

Before discussing covering index further, it should be understood that a covering index is not a separate type of index that has a different internal structure and algorithm. It is just a technique that is used to boost up the performance of data retrieval for the table.

You may wonder If it is not a new type of index, why do we need to use it?

Run the same SELECT query that we ran earlier in the Increasing performance by creating non-clustered index section, which was creating the non-clustered index seek operation. But now, run this query with some more fields in the SELECT clause, may be like this:

--running the same query we ran earlier to see behavior after --Non-Clustered Index was created with just ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.