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: 1277 | 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

Bookmark It

< Previous : How to fetch Month Number from any specified Month ...

Next > : How to update the statistics for an index?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions