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