In DB2, you need to know Rusnstats utility when it has to run. Ideas that are given in this post help you to make a decision.
Tag: RUNSTATS Utility
DB2 Collects Table statistics in an automated way. This post tells you how Optimizer uses the Statistics for a better SQL query execution plan.
Srinimf 