INFORMIX: Database statistics for table &1 are obsolete (Threshold: &2 %)

Message type: E = Error

Message class: RSCV - Analysis of BW objects (InfoCubes...)

Message number: 542

Message text: INFORMIX: Database statistics for table &1 are obsolete (Threshold: &2 %)



What causes this issue?

The database statistics for table &v1& are obsolete. With a chosen
threshold of &v2& %, this means that at least &v2& % of the data in the
table in question has been added, or deleted, and no 'update
statistics' has been carried out since. The threshold is defined on the
tabstrip <LS>Performance</> of an Infocube (InfoCube -> Maintain
content, or InfoCube -> Performance).
No correct statistical information is in the database optimizer. This
can lead to bad run schedules and thereby to poor performance.


How to fix this error?

Build up current database statistics for table &v1&. For this, use a
repair routine, that is assigned to this analysis routine (function
<PF>Remove error </>in the transaction <ZH>RSRV</>).

Error message extract from SAP system. Copyright SAP SE.