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:

  1. See the above Good to Know point about timing of this report.
  2. 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.