[
https://issues.apache.org/jira/browse/TRAFODION-2673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2673.
---------------------------------------------
Resolution: Fixed
> Improve performance of incremental UPDATE STATISTICS
> ----------------------------------------------------
>
> Key: TRAFODION-2673
> URL: https://issues.apache.org/jira/browse/TRAFODION-2673
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Environment: All, but most noticeable on large sample tables
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> When running an incremental UPDATE STATISTICS utility, rows satisfying the
> WHERE clause are first deleted from the sample table, then replaced with a
> new sample taken from the base table.
> The statement used to delete rows from the sample table is a vanilla DELETE,
> which performs poorly when the set of rows to be deleted is large. It would
> be better (and much faster) to use DELETE NO ROLLBACK.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
