Why does DB20 report statistics as obsolete, even if they have just been created?
DB20 compares the current number of rows in the table with the number of the rows the last time the statistics were created. If the difference between these numbers exceeds a defined threshold value (default value is 50%), the statistics are regarded as obsolete. To estimate the current number of table entries, an analysis of the primary index is performed with the default statistics accuracy. If the accuracy is low or the index is heavily fragmented, the estimated result deviates significantly from reality and DB20 reports obsolete statistics, even though the statistics are current. In most cases, reconstructing the index (see Note 332677) or creating the statistics with greater accuracy helps in this case.
Related Questions
- What do I have to do to get SysMetrix to report on my motherboard statistics such as temperatures, fan speeds, etc?
- zWebTülz Statistics generates a report about activity on my Web server. Where does it get the information?
- Where can I find information on using Desk Tracker to report instruction statistics?
