[
https://issues.apache.org/jira/browse/TRAFODION-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-3266.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.4
> 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
> Priority: Major
> Fix For: 2.4
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> 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)
