Description
INFORMIX System Monitoring Interface Tables
sysdistrib (Data Distribution Information)
Column Type Description
tabid INTEGER Table identifier of the table where data
was gathered
colno SMALLINT Column number in the source table
seqno INTEGER Sequence number for multiple entries
constructed DATE Date when the data distribution was
created
mode CHAR(1) Optimization level:
L = Low
M = Medium
H = High
resolution FLOAT Specified in the update statistics
statement
confidence FLOAT Specified in the update statistics
statement
encdat CHAR(256) ASCII encoded histogram in fixed-length
character field; accessible only to user
informix.