How to do the UPDATE STATISTICS in SQL Server?
If you want to find out if an index has had its indexes updated or not, you can use the command, like this:
DBCC SHOW_STATISTICS (table_name , index_name)
This command will not only tell you when statistics were last updated, but also provide you information on the kind of statistics that has been collected for the index you are examining.
You can update the statistics using this command:
USE <database_name>
EXEC sp_updatestats