Table Statistics

To query statistics information, see Querying statistics.

To update statistics information, see ANALYZE statement.

Starting on Jan2022 release, in order to mitigate the I/O required to update the sys.statistics table, this table is no longer persisted. It has been changed into a table producing system function sys.statistics() and a system view sys.statistics. Hence it is also no longer possible to do updates or deletes on this table (to remove old statistics). Use ANALYZE statement instead.