Further looking at the Extended Diagnostic Information:
Extended Diagnostic Information:
--------------------------------
Diagnostic Identifier: 1
Diagnostic Details: EXP0045W The table named "DB2INST1 "."PROCESS" has
fabricated statistics. This can lead to poor
cardinality and predicate filtering estimates. The
size of the table changed significantly since the
last time the RUNSTATS command was run.
In this case, the statistics are outdated and we end up fabricating the statistics.
NOTE: The fabricate statistics message above is fairly new and added in v9 fixpack 5.
Details on Fabricated statistics:
The fabricated statistics are saved in the internal packed descriptor if its statistics show a smaller
number of records compared to the Update, Delete, and Insert (UDI) counters. If the newly
fabricated statistics show a larger number of records compared to the UDI counters, the same
fabricated statistics may still remain until it is reset by runstats because the statistics fabrication
does not work when npages > 1, fpages > 1 and card > 1 in cache and some of those value may
be increased by the previous fabrication.
The change in the fabricated statistics may lead to changes in the plan chosen for the query
execution.