Row count values for the number of rows, number of forwarded rows, and number of deleted rows may be inaccurate, especially if query processing includes many rollback commands. If workloads are extremely heavy, and the housekeeper wash task does not run often, these statistics are more likely to be inaccurate.
Running update statistics corrects counts in systabstats.
Running dbcc checktable or dbcc checkdb updates these values in memory.
When the housekeeper wash task runs, or when you execute sp_flushstats, these values are saved in systabstats.
You must set the configuration parameter housekeeper
free write percent to 1 or greater to enable housekeeper
statistics flushing.
