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
Hi
I am new to the forum and I would like to know how I can create a discussion on a SQL-Security topic
If anyone can show me that would be really nice.
Regards
Fred
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!!!!