Post reply

SP_UPDATESTATS

  • November 21, 2003 at 2:26 pm

    #59033

    Quick question: after doing DBCC INDEXDEFRAG on a specific table, do I need to run SP_UPDATESTAS?

    Thanks.

  • November 24, 2003 at 7:33 am

    #483345

    Would be good .I believe if your database is configured to automatically update stats which is supposed to be a good config.

    Then you may not have to worry too much about it

    Mike

  • December 2, 2003 at 8:12 am

    #484300

    Hi,you could also try

    UPDATE STATISTICS 'tablename'

    with FULLSCAN,

    ALL

    go

    Roy

  • December 2, 2003 at 11:17 am

    #484327

    thanks everyone. This is an app with sql as backend, both are supported by a vendor. However during the day it intermitenly happens to be slow during search. I can't touch the app or see the codes. The vendor has a nightly maintenance job so they don't seem worry about this. The only thing I can do is to defrag the indexes used in the search (captured in profiler) and just wonder if I need to update statistics. Actually after defrag and update statistics the app rocks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply