How to find out if any index has updated or not?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 259 | Points: 40
Answer:

We can use the dbcc show_statistics command as:-

dbcc show_statistics(table_name,index_name);

Note:- This command will not tell us when statistics were last updated.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response