• It's not going to get you better plans or better performance. If the stats you dropped weren't needed, they were never used. If they were needed, they'll be recreated. Stats that are unused can't, by definition affect plans (if they could, then they wouldn't be unused)

    It'll reduce the time of any 'update all stats' maintenance jobs, but that's about it.

    If you want to do it, be advised that you will get higher load and slower queries initially, so don't do it at peak time and don't do it repeatedly. Also note that the recreated stats will be sampled, which if you've been updating stats with fullscan could result in poor query plans until that update with fullscan kicks in.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass