I ran a query on SQL server that found duplicate statistics. As a result of this query, 1 record was returned. Under the AutoCreatedStatistics column it says "_WA_Sys_XX" and under the Index column it says "_dta_index_XX". As far as I understand, these two are duplicates. I want to delete 1 of them. But how do I decide which one I should delete? After making the decision, in order to delete statistics from SSMS, I need to hover over the statistics, right-click and look for the delete button, but the Delete button appears greyed out. Does anyone know why it looks gray?

1 Answer 1


There’s a very high probability that no matter which one you delete, SQL Server will recreate it. If I were you, I would probably try to refocus my efforts on something that would solve a problem or improve circumstances for users of your database.

  • 3
    100% agreement, but since one of those says "dta_" I'd sure drop that... and then stop running the DTA against the database. Commented Jan 31 at 12:57
  • 1
    @GrantFritchey DTA is a four letter word, yes indeed. Commented Jan 31 at 13:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.