What is a Covered Index in SQL Server ?
It is an index that can satisfy a query just by its index keys without having needed to touch the data pages is called Covering Index. It means that when a query is fired, SQL Server doesn’t need to go to the table to retrieve the rows, but can produce the results directly from the index as the index covers all the columns used in a query.