SQL Server: How to find auto created Statistics Objects?

In this post, I am going to share one script to find a list of auto generated statistics objects of the SQL Server.

When the automatic create statistics option, AUTO_CREATE_STATISTICS, is on, the query optimizer creates statistics on individual columns.

Whenever we are updating the data of statistics objects, it is required to find particular statistics object name of the column.
The auto generated statistics object starts with _WA.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of