[
https://issues.apache.org/jira/browse/TRAFODION-2781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16219578#comment-16219578
]
ASF GitHub Bot commented on TRAFODION-2781:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/1276
> UPDATE STATS unnecessarily creates LOB columns in sample tables
> ---------------------------------------------------------------
>
> Key: TRAFODION-2781
> URL: https://issues.apache.org/jira/browse/TRAFODION-2781
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.3-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Minor
>
> When UPDATE STATISTICS creates a persistent sample table, it uses CREATE
> TABLE LIKE, which means that the sample table will get LOB columns even
> though we don't support statistics on LOBs. Moreover, we will populate these
> LOB columns. This is an unnecessary overhead.
> We could improve the efficiency of UPDATE STATISTICS on tables with LOB
> columns by omitting the LOB columns when creating the sample table, and
> omitting the logic to populate them.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
