[
https://issues.apache.org/jira/browse/TRAFODION-2376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15951488#comment-15951488
]
ASF GitHub Bot commented on TRAFODION-2376:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/1029
> Improve UPDATE STATISTICS performance for varchar columns
> ---------------------------------------------------------
>
> Key: TRAFODION-2376
> URL: https://issues.apache.org/jira/browse/TRAFODION-2376
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
