Home Forums SQL Server 7,2000 Performance Tuning UPDATE STATS WITH FULLSCAN - best way to implement? RE: UPDATE STATS WITH FULLSCAN - best way to implement?

  • August 11, 2011 at 7:11 pm

    #1367685

    dheeraj gupta (8/11/2011)

    Thanks for quick response.

    Then how to leave specifically for which statistics has been updated while rebuild the table indexes and update the stats for rest of the things?

    Need it for not to waste maintainance time in updating the stats for which it has already been updated when it rebuilt.

    Thanks.

    Agreed. At my current client, updating all stats with fullscan takes less than 30 minutes... with a 10 hours window. I've also tuned the index maintenance phase to death. By now I rarely, if ever, get more than 4-5 index being rebuilt every day. So out of 30K indexes, I don't care to redo the stats work for 5 of them.

    You can read my full evolution around that over here : http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx