Statistics are important for query optimizer to generate optimal query plans. If you have outdated or stale statistics for your index then your query's performance will suffer. Therefore, it is important to update the statistics to make sure query optimizer always generates the best and optimal plan.
This script allows you to report and/or update outdated/stale statistics for either individual indexes or for all indexes in a databases and for all indexes across all user databases.
This script provides the following information:
1. Name of the Database
2. Table Name
3. Index Name
4. Last date when Statistics was Updated
5. Row Count of the Table
6. Number of Rows Changed
7. Percentage of Row Changes Occurred Since Last time Statistics were Updated
8. Script for you to manually execute Update Statistics on individual objects