sarabpreet.com
Using Covering Index
A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is called Covering Index. In other words When all columns which are required to satisfy the…