Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8

    Unanswered: How often should stats be run?

    Hello,
    How often should stats be run? Also, is there any reason not to run them too often?
    Thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    As you run analyze on tables and indexes, you place "locks" on the
    objects ...

    How often you run them is up to the activity level on the database.
    If you are not doing a "LOT" on DML on the database,
    you can get by with not running them as often ... You just want
    to be sure you run them to give Oracle a "Good" chance at choosing
    the correct query path.

    ps... This is only if you are using the cost based optimizer ...

    HTH
    Gregg

  3. #3
    Join Date
    Oct 2003
    Posts
    87
    A Stats run should be "event" based rather than by time or period. What I mean is that significant changes to data should trigger a Stats run. Examples would be: inserts/deletes, skewing within an index, (re)partitioning, etc. There are examples in the Manuals of scripts that can determine these events and kick off a Stats run for a particular object. See StatsPack.
    Oracle - DB2 - MS Access -

Posting Permissions

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