November 21, 2014 at 2:47 am
We have implemented a very small reporting database which has a main table that started off small and has now grown to around half a million rows. Initially, there were no indexes on the table apart from a clustered index, but as the data has grown, performance has dropped and so we have added a number of indexes. This has resolved the performance issues.
Before creating the indexes SQL Server had auto created a number of statistic objects (_WA_Sys_000... etc). After creating the indexes, new statistic objects where created for the new indexes. In some cases, there are duplicate statistics (auto and index) for the same columns.
Should I go through and drop the duplicate auto statistics? Will having duplicates cause issues at all?
Thanks.
November 21, 2014 at 3:01 am
Should I go through and drop the duplicate auto statistics? Will having duplicates cause issues at all?
No issues at all
-- Gianluca Sartori
November 21, 2014 at 3:04 am
Perfect. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply