Out of Date Index Statistics
Run the Health Check Tool and select the Out of Date Index Statistics rule. This rule retrieves tables where a large number of rows have been created and the statistics are not up to date with the row count.
Good to Know
- If you have a hosted system, a nightly job is run to update the statistics, so you should generally never see information in this section unless you run the Health Check just prior to the job running.
- If your system is on-premises, we recommend that you ask your DBA to run this command to update these statistics: exec sp_updatestats.
To see information about Out of Date Index Statistics:
- See the above Good to Know point about timing of this report.
- Select the Out of Date Index Statistics check box when you Run the Health Check Tool.
You see the Out of Date Index Statistics in the report.