Major Description
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.
Attachments
Issue Links
- links to
