[ https://issues.apache.org/jira/browse/TRAFODION-2781?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-2781. --------------------------------------------- Resolution: Fixed Fix Version/s: 2.3-incubating > 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 > Fix For: 2.3-incubating > > > 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)