How can we know the Index usage on Tables?

Posted by vishalneeraj-24503 on 2/2/2015 | Category: Sql Server Interview questions | Views: 445 | Points: 40

Answer:

By using below technique, we can know the Index plan on any Tables:-
Execution plan
SET STATISTICS PROFILE ON

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What do we mean by Cursor functions in Sql Server?

Next > : What do we mean by Pages in Sql Server and How man ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions