[
https://issues.apache.org/jira/browse/TRAFODION-1775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-1775.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.0-incubating
Fixed. Added code to raise a warning or error if an UPDATE STATS is done on a
large table without the SAMPLE clause.
> Raise a warning or error if UPDATE STATS is done w/o SAMPLE on a large table
> ----------------------------------------------------------------------------
>
> Key: TRAFODION-1775
> URL: https://issues.apache.org/jira/browse/TRAFODION-1775
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.0-incubating, 1.3-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Fix For: 2.0-incubating
>
>
> If UPDATE STATISTICS is done on a very large table (say, 17 billion rows)
> without a SAMPLE clause, it can take hours to finish. The reason is that
> there is not enough memory to do things in memory, so it will in the worst
> case rescan the entire table for each histogram to create. The larger the
> table the worse it gets.
> The suggestion, then, is to raise an error if this is done unless syntax
> overrides it. And in the latter case raise a warning.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
