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.