[jira] [Created] (TRAFODION-2781) UPDATE STATS unnecessarily creates LOB columns in sample tables

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

David Wayne Birdsall created TRAFODION-2781:
-----------------------------------------------

             Summary: 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)