SAP Table DBSTATHINF

INFORMIX update statistical information

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