The DBSTATHINF table in SAP ERP or S/4HANA stores INFORMIX update statistical information data. There are total 14 fields in DBSTATHINF table. The INFORMIX update statistical information table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBSTATHINF table. It is in Informix: STUN (STUN_INF) ABAP package and is part of the Workload Monitoring Tool (BC-CCM-MON-TUN) module.
SAP DBSTATHINF Table Fields
Following is the list of fields that are available in SAP DBSTATHINF table. The primary key fields of INFORMIX update statistical information table in SAP are TABID (Table ID), TABNAME (Informix table name (according to systables)), LUPDSTAT (Analysis date (yyyymmddhhmm)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TABID | Table ID | INF_TABID | INT4 (10) | |
| TABNAME | Informix table name (according to systables) | INF_TABNAM | CHAR (18) | |
| LUPDSTAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| CUPDSTAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR (12) | |
| LASTROWS | Number of rows at last statistics update | INF_LROWS | INT4 (10) | |
| CHECKROWS | Number of rows at last check | INF_CROWS | INT4 (10) | |
| THRESHOLD | Threshold for update statistics | INF_THRESH | INT2 (5) | |
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 (3) | |
| VALUE | Analysis Method for Collecting Statistics | AM_AMETH | CHAR (4) | |
| DURATION | Duration of update statistics | INF_DURAT | INT4 (10) | |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR (2) | |
| TABNPUSED | Number of data pages used | INF_DPAGES | INT4 (10) | |
| IDXNPUSED | Number of index pages used | INF_IPAGES | INT4 (10) | |
| TABFILL | Table fill level | INF_TFILL | INT2 (5) |
