Data modification can affect many of the values in the systabstats table. To improve performance, these values are changed in memory and flushed to systabstats periodically by the housekeeper chores task.
If you need to query systabstats directly, you can flush the in-memory statistics to systabstats with sp_flushstats. This command flushes the statistics for the titles table and any indexes on the table:
sp_flushstats titles
If you do not provide a table name, sp_flushstats flushes statistics for all tables in the current database.
Some statistics, particularly cluster ratios, may be
slightly inaccurate because not all page allocations and deallocations
are recorded during changes made by data modification queries. Run update
statistics or create index to correct
any inconsistencies.
