• As Gila has mention UPDATE STATISTICS with FULLSCAN is good. Refer following link for your reference:

    http://sqlperformance.com/2013/07/sql-statistics/statistics-updates

    https://msdn.microsoft.com/en-IN/library/ms187348.aspx

    https://msdn.microsoft.com/en-IN/library/ms173804.aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."