Wide Columns and Optimizer Statistics

When placing statistics on a wide column, the server uses on the first 255 bytes of data. Even if you place an index on a column created as char(500), only the first 255 bytes will contribute towards the column histograms in sysstatistics. For unichar columns, the first 127 chars will be used to gather column distributions.