DB2 Collects Table statistics in an automated way. This post tells you how Optimizer uses the Statistics for a better SQL query execution plan.