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

To query systabstats directly, use sp_flushstats to flush the in-memory statistics to systabstats. For example, to flush the statistics for the titles table and any indexes on the table, use:

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.