Question : What is a covered index?

A covered index can satisfy a query just by its index keys without having the need to touch any data pages. When an Index covers the query in this way it is a 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 query.

Thanks for reading this article,

Next steps :

1.    Share this with your colleagues because Sharing  is Learning

       2.    Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!