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

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

     [ 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)