How To Fix S1091 - No table statistics found for application server &

S1091 - Overview

• Message type: E = Error

• Message class: S1 - Statistik / SAP-Monitor

• Message number: 091

• Message text: No table statistics found for application server &

What causes this issue?

There are no table CALL statistics in the performance database MONI or
in the main storage area (for your own instances) for the selected
application server/instance.

System Response

You do not get any analysis data of the table statistics.

How to fix this error?

The CALL statistics have possibly been switched off on the computer by
the startup profile parameter rsdb/staton = 0. It is also possible that
the data was deleted by the regular reorganization run. You can
increase the residence time of the data for the table statistics in the
performance database with transaction ST03 by choosing the menu options
<LS>GOTO -> PARAMETERS</>. The call statistics use the time value for
"Long-Term" dates as a residence time.

Error message extract from SAP system. Copyright SAP SE.

S1091 - Details

• The SAP error message S1091, which states "No table statistics found for application server &," typically indicates that the SAP system is unable to find the necessary statistics for a specific database table on the specified application server. This can lead to performance issues, as the database optimizer relies on these statistics to make informed decisions about how to execute queries efficiently.
  Causes:
  
  Missing Statistics: The most common cause is that the database statistics for the specified table have not been generated or updated.
  Database Configuration: There may be issues with the database configuration or connectivity that prevent the retrieval of statistics.
  Transport Issues: If the table was recently transported from another system, the statistics may not have been transported along with the table definition.
  Database Maintenance: Regular maintenance tasks, such as database reorganization or updates, may have led to the loss of statistics.
  
  Solutions:
  
  
  Generate Statistics:
  
  Use the appropriate database tools or SQL commands to generate or