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)
