I have been experimenting with using MAXVALUELENGTH to make additional columns in multi-column stats significant. I have not been able to find anywhere a definition for what the maximum value is for this stats attribute. Contrary to MAXINTERVAL (which is capped at 500), all I can find is "For multicolumn statistics, the valid range of n is 1 - combined maximum size of all the
columns." Doesn't quite work that way. I seem to hit a wall somewhere in the 950's. Anyone have any insight into this?
P.S. all char/varchar columns at my client are UNICODE and many are defined as, say, VARCHAR(200) or VARCHAR(500) whether they need it or not (partly due to this being a forklift).