SQL Server Performance

updatestats

Discussion in 'Performance Tuning for DBAs' started by hooperdba, Mar 30, 2007.

  1. hooperdba New Member

    I have a weekly maintenance program that deletes around 100,000 records from various application tables.
    Question is :

    Do I need to run an sp_updatestats after this job?
    I already have updatestats selected in DB options.
    thanks
    hooperdba, Mar 30, 2007
    #2

  2. Luis Martin Moderator

    I believe yes.

    If I were you I'll update statistics of those tables with fullscan (night job).


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Mar 30, 2007
    #2

  3. hooperdba New Member

    thanks
    hooperdba, Mar 30, 2007
    #2

Share This Page