Index Covering in SQL

Question

Hi Friends What is index covering of a query in SQL ?

R ACHUTHA · Answer

A covering index is one which can satisfy all requested columns in a query without performing a further lookup into the clustered index. There is no such thing as a covering query. Have a look at this Simple-Talk article: Using Covering Indexes to Improve Query Performance .