Wide columns and optimizer statistics

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.