David Wayne Birdsall created TRAFODION-3266:
-----------------------------------------------
Summary: UPDATE STATISTICS should use SKIP CONFLICT ACCESS when
accessing the base table
Key: TRAFODION-3266
URL: https://issues.apache.org/jira/browse/TRAFODION-3266
Project: Apache Trafodion
Issue Type: Improvement
Components: sql-cmu
Affects Versions: 2.4
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
Today, UPDATE STATISTICS uses READ UNCOMMITTED ACCESS when accessing the base
table. Unfortunately, our engine maps this to READ COMMITTED ACCESS. In a
scenario where data ingest happens continuously, this may lead to transaction
conflicts between the full table scan done by UPDATE STATISTICS and data ingest
transactions that wish to commit.
By changing UPDATE STATISTICS to use SKIP CONFLICT ACCESS, we can avoid such
conflicts.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
