Timeouts unless statistics updated

From: phorvath6 (phorvath6_at_cox.net)
Date: 05/11/04

  • Next message: Efrat: "Re: SQL Server/ADO/XP problem "query cannot be executed"" 
    Date: Mon, 10 May 2004 22:28:47 -0700

    A single table in one of our SQL 2K databases stops responding to select
    queries about once per week at random times. Queries executed against the
    table by another application hang indefinitely and query analyzer can't come
    up with an execution plan even for a simple select * from the table. The
    solution has been to recompute the statistics for the table. The indexes are
    rebuilt and stats recomputed weekly which seems like it would take care of
    this but it isn't. Any suggestions how to avoid this situation or ideas what
    could be causing it would be greatly appreciated.

    Best regards,

    Paul

  • Next message: Efrat: "Re: SQL Server/ADO/XP problem "query cannot be executed""
    Loading