Do parallel SELECTs make a transaction?
1
vote
2
answers
294
views
While running under
READ COMMITTED
(the pessimistic type, not RCSI), I've just seen an UPDATE
's IX lock deadlock with a SELECT
's shared lock on the PAGE
-level. The SELECT
ran with a parallel execution plan. Neither explicitly used a transaction. I understand that UPDATE
s implicitly create transactions. Does this suggest that parallel SELECT
s also create implicit transactions? Is this not true of non-parallel SELECT
s?
I'm finding this rather confusing, because none of the textbook examples of deadlocks show two transaction-less queries deadlocking.
Asked by J. Mini
(1237 rep)
Oct 17, 2024, 03:51 PM
Last activity: Oct 18, 2024, 12:18 PM
Last activity: Oct 18, 2024, 12:18 PM