Optimization statistics feedback
In Db2 11, Db2 identifies statistics values that are missing or conflicting when it selects access paths for SQL statements. Db2 externalizes data about the missing or conflicting statistics as optimization feedback in certain catalog and EXPLAIN tables.
Db2 externalizes data about
the missing or conflicting statistics to the following tables:
- The DSN_STAT_FEEDBACK table, when you capture EXPLAIN information
- The SYSIBM.SYSSTATFEEDBACK catalog table, at the specified statistics interval
You can use the feedback data to identify missing or conflicting statistics to collect. Optimization tools can also use the optimization feedback data to recommend the collection of such statistics.