Forum Discussion
Cleanup of auto created statistics
You can drop the WA_ statistics manually. When the Query Optimizer does not find statistic it needs, it will automatically create it.
But if the table is not modified frequancy, the statistic exists can be used by Query Optimizer without or with few updates. Comparatively, process of creating statistic will slowdown query. So if it's not very necessary, you'd better not to drop statistics manually. After SQL Server 2022, there is a option can drop statistics automatic.
Check the document https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16
Just click the button Start Discussion on the upper right corner of the space page of SQL Server Engine. After edit your question, choose tags like SECURITY and SQL you want under the editor.
thanks rodgerkong!!!!