October 28, 2017 at 10:27 pm
I have a table with 50 columns, 15 indexes and 100+ statistics. I thought statistics were for indexes. I can't delete them as the "delete" option is dimmed on the right click menu. Could these be slowing the read of the table down? Should I get rid of them? How would I get rid of them?
Thanks !
Mike
October 28, 2017 at 11:14 pm
You can get rid of them by dropping them (DROP STATISTICS). The Query Optimiser will recreate them as soon as it needs them, so unless the pattern of work has changed significantly since the table was created, they'll all be back in a couple of days.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply