Microsoft KB Archive/70857: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70857 to Microsoft KB Archive/70857 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:29, 12 August 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.