Microsoft KB Archive/70857

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.