Microsoft KB Archive/70857: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
(No difference)
|
Revision as of 18:58, 18 July 2020
PRSQL9103037: Updating in Browse Mode Can Cause a Deadlock ID Number: Q70857
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103037
SYMPTOMS Trying to update in browse mode causes a deadlock if the table size is greater than 1024 bytes and a nonclustered, unique index is used.
CAUSE This problem is related to the use of a nonclustered index, since the optimizer does not always choose to use this type of index.
RESOLUTION Use a clustered unique index on this type of table.