Does Truncate Table Reset Statistics?
Category:
query-performance
, sql-server
Short answer: the SQL Server optimizer will know that the table was truncated, but statistics might not update when you expect.
For the long answer, let’s walk through an example using the WideWorldImporters sample database.