How query processing affects systabstats

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 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.

NoteSome 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.