How To Fix DB6127 - Tabellenstatistiken sind aktuell

DB6127 - Overview

• Message type: E = Error

• Message class: DB6 - DB6: Alert Monitoring and Alert Configuration

• Message number: 127

• Message text: Tabellenstatistiken sind aktuell

Copy of 1st and 2nd blocks of DB6 126

Was verursacht dieses Problem?

Among other things, statistical information about tables (size,
distribution of values, and so on) is stored in the database system
tables (system catalog). The optimizer then analyzes this informaiton
when creating access plans for SQL statements.
For tables with variable datasets (transaction data), this statistical
information must be regularly adjusted.

Systemantwort

The better these statistics, the better the optimizer can create plans.
Conversely, obsolete data or statistics that are missing completely can
cause poor access plans and therefore poor performance.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE