Do you have Key Lookup problem? Key lookup taking most of the query time. then probably this is the best time to know more about covering indexes. Covering Index can solve all key lookup problems. A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is called Covering Index.
To know more read Using Covering Index.
Happy Learning 🙂
Sarabpreet Singh Anand
Subscribe now to get latest Tips in your Inbox