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 these 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.
The configuration parameter housekeeper free
write percent must be set to 1 or greater to enable housekeeper
statistics flushing.
