Adaptive Server uses only the first 255 bytes of data when
placing statistics on a wide column. For example, only the first
255 bytes contribute to the column histograms in sysstatistics if
you place an index on a column created as char(500)
.
For unichar columns, the first 127 chars are
used to gather column distributions.