Contains one row for each column of data type NUMERIC. Used by the optimizer, each row contains a sampling of values in the column.

The following table provides details of the SYSNUMSTAT table.

Table 1. SYSNUMSTAT system table
Column name Column data type Column size
colid INTEGER 4
tblid INTEGER 4
value NUMERIC 32
property INTEGER 4
attribute INTEGER 4