5
Optimizer Access Path Selection
1. Gets the current statistics from DB2
catalog for the columns and tables
identified in the SQL statements. These
statistics are populated by the Runstats
utility.
2. Computes the estimated percentage of
qualified rows for each predicate - which
becomes the filter factor for the predicate.