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

The following table provides details of the SYSNVARCHARSTAT table.

Table 1. SYSNVARCHARSTAT system table
Column name Column data type Column size
colid INTEGER 4
tblid INTEGER 4
value VARCHAR 2000
property INTEGER 4
attribute INTEGER 4