Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Treviso (Italy)

    Unhappy Unanswered: Statistics degrade


    another daily problem ...

    I've a table with half million records that my application uses continious with several UPDATE e SELECT statement (about 5 requests/sec).
    After several (4-5) hours I've a degrade of performance, but if I update the statistics (of thi table) all return ok.

    Now the situation is I create a job to maintenance this table updating statististic two times a day ....

    Is it normal? SQL should update statistics by itself?
    I choose the wrong way or ... what can i do?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Without knowing a lot more about what your configuration looks like, how the table(s) is being used, etc. I'm going to have to guess. If you are changing 15-20% of the rows in the table (from your description), I'd expect to need to update statistics.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts