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

The following table provides details of the SYSFLOATSTAT table.

Table 1. SYSFLOATSTAT system table
Column name Column data type Column size
colid INTEGER 4
tblid INTEGER 4
value FLOAT 4
property INTEGER 4
attribute INTEGER 4