SAPDBA gives you the chance to update statistics on tables in the Informix database if necessary when you view SAPDBA index reports.
A message like the following is sometimes displayed when you choose theindexes by table or index information reports in SAPDBA:
Statistics for table d010q are out of date!
Parts of the displayed data will be out of date too. Update statistics for this table will refresh them.
Run Update statistics for this table now?
This message means that the table has been updated substantially since the last time statistics were updated for it, or it is a new table without any statistics. Therefore, SAPDBA cannot accurately derive the table’s indexes for the report you have requested. You have to decide whether or not to update statistics:
Running update statistics for table d010q...
Then the report screen is up-to-date.
For a new index or if the entire indexed table is new (that is, without any previous statistics), the message is slightly different:
Table 'd010q’ has one or more indexes that were created after the last run of 'Update Statistics'. To display the whole data and for performance reasons it is strongly recommended to run 'Update Statistics' for this table!!
Run update statistics for this table now?
Choose whether you want to update the statistics or not.
If you do not update statistics, for new indexes SAPDBA displays hyphens in the fields that it cannot fill.
The statistics on the table are up-to-date, so improving database performance.