DBSTATTINF - INFORMIX update statistical information

INFORMIX update statistical information information is stored in SAP table DBSTATTINF.
It is part of development package STUN_COMMON in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "STUN".

Fields for table DBSTATTINF

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
TABIDTable IDXINF_TABIDINT44
TABNAMEInformix table name (according to systables)INF_TABNAMCHAR18
LUPDSTATAnalysis date (yyyymmddhhmm)AM_DATECHAR12
CUPDSTATAnalysis date (yyyymmddhhmm)AM_DATECHAR12
LASTROWSNumber of rows at last statistics updateINF_LROWSINT44
CHECKROWSNumber of rows at last checkINF_CROWSINT44
THRESHOLDThreshold for update statisticsINF_THRESHINT22
SIGNISignificance for Collection of StatisticsAM_SIGNIINT11
VALUEAnalysis Method for Collecting StatisticsAM_AMETHCHAR4
DURATIONDuration of update statisticsINF_DURATINT44
VWTYPType of Usage of Table EntryAM_VWTYPCHAR2
TABNPUSEDNumber of data pages usedINF_DPAGESINT44
IDXNPUSEDNumber of index pages usedINF_IPAGESINT44
TABFILLTable fill levelINF_TFILLINT22
Privacy Policy