DBSTATTINF

INFORMIX update statistical information | #transactional | Component: Workload Monitoring Tool
Column Name Description
TABID Table ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SIGNI Significance for Collection of Statistics Show values
VALUE Analysis Method for Collecting Statistics Show values
VWTYP Type of Usage of Table Entry Show values
Column Name Description Domain name
TABNAME Informix table name (according to systables) INF_TABNAM
LUPDSTAT Analysis date (yyyymmddhhmm) CHAR12
CUPDSTAT Analysis date (yyyymmddhhmm) CHAR12
LASTROWS Number of rows at last statistics update INT4
CHECKROWS Number of rows at last check INT4
THRESHOLD Threshold for update statistics INT2
DURATION Duration of update statistics INT4
TABNPUSED Number of data pages used INT4
IDXNPUSED Number of index pages used INT4
TABFILL Table fill level INT2