Progress
SQL-92
Guide and Reference


SYSNUMSTAT System Table

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

Table B–16: SYSNUMSTAT System Table 
Column Name
Column Data Type
Column Size
colid
INTEGER
4
rssid
INTEGER
4
tblid
INTEGER
4
val1
NUMERIC
32
val2
NUMERIC
32
val3
NUMERIC
32
val4
NUMERIC
32
val5
NUMERIC
32
val6
NUMERIC
32
val7
NUMERIC
32
val8
NUMERIC
32
val9
NUMERIC
32
val10
NUMERIC
32


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095