Major Description
Today when UPDATE STATISTICS uses internal sort, varchar columns are expanded out to their maximum length with blank padding. This can be quite wasteful both of memory and CPU cycles, as often the average length of a varchar is much less (even orders of magnitude less) than the maximum length. We can do much better performance wise by not doing this expansion, at the cost of some complexity in comparison.
Attachments
Issue Links
- links to
