Deepak has written an aritcle on Index Usage in www.sql-articles.com. You can check out the article in the link below.
I have used the Contact table with person schema which is residing in AdventureWorks database for testing the index usage. I am describing the scenarios and places where index seek or scan will be used.
0 Comments.