Hi @Heisenberg ,
When one of the following changes occurs, the statistic is considered outdated, and an update action is automatically triggered the next time the table is used.
(1) The table has changed from no data to more than or equal to 1 data.
(2) For tables with less than 500 rows of data, when the cumulative change of data in the first field of statistical information is greater than 500.
(3) For tables with more than 500 rows of data, when the cumulative change of data in the first field of statistical information is greater than 500 + (20% × total amount of table data).
Therefore, for large tables, only more than 1/5 of the data changes, SQL Server will recalculate the statistics.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".