Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Unanswered: Is it possible to mass update stats?

    SQL Server 2000 on Win2k

    I'm fairly new to SQL Server and I'm just wondering if it's possible to Update Statistice for all indexes somehow? I'm looking at the Update Statistics command and it doesn't seem to be possible.

    The situation we have is a reporting DB that basically has all it's tables truncated and remade every night by some DTS jobs that import from another datasource and change the data and build some denormalzed tables etc.
    Some of the large Insert operations go from taking 8 mins to taking several hours sometimes and updating the stats seems to fix the problem for a while. So I'd like to make sure the optimizer has all the latest stats for all tables.

    Any other advice would be appreciated.

    Cheers.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

  3. #3
    Join Date
    Jul 2004
    Posts
    306
    Cool cheers ... From the help on that it doesn't seem like I can set the sample size.
    From that I noticed links to sp_createstats so I might drop the stats and recreate them with a higher sample rate.

    THANKS!

Posting Permissions

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