|
|
|
|
|
|
by mattb314
1957 days ago
|
|
|
I doubt it? At least the number times the "last updated" column appears on SQL server stats [1] leads me to believe it collects stats async with updates to the table. The only system I've heard of that relies on up-to-date statistics for correctness is snowflake (long but interesting talk here [2]), where having accurate max/mins for each micro partition is really helpful for cutting down the amount of data in the large range scan queries common in BI. I'd guess that being a BI system, snowflake can get away with higher row update latency too. [1] https://www.sqlshack.com/sql-server-statistics-and-how-to-pe... [2] https://www.youtube.com/watch?v=CPWn1SZUZqE |
|
|