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. Continue reading Sql Server Interview question: What is a covered index? →