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
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.
answered Jan 31 at 12:32
Erik Reasonable Rates DarlingErik Reasonable Rates Darling
44.2k14 gold badges140 silver badges514 bronze badges
-
3100% 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