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. When the housekeeper wash task runs, or when you execute sp_flushstats, row count values are saved in systabstats.
You must set the configuration parameter housekeeper
free write percent to 1 or greater to enable housekeeper
statistics flushing.
Running dbcc checktable or dbcc checkdb updates these row count values in memory.
