Menu

SAP Table DBSTATHINF

INFORMIX update statistical information

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table DBSTATHINF (INFORMIX update statistical information) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table DBSTATHINF
Short Text INFORMIX update statistical information
Package STUN
Table Type Transparent Table

Fields for Table DBSTATHINF

Field Name Key Description Data Element Type Length Check Table
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