David Wayne Birdsall created TRAFODION-2673:
-----------------------------------------------
Summary: 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)
