Re: DEADLOCK Problem
Hallo ccrow,
kann die Anzahl der betroffenen Rows beim UPDATE eingeschränkt werden?
z.B.
UPDATE tabelle
SET feld1 = 5
WHERE id BETWEEN 1 AND 1000;
- Setzen die Programme einen explizten LOCK ab?
- Kannst Du Testweise den UPDATE in einen SELECT umschreiben und dann mit EXPLAIN testen. Dann zeigen sich eventuell Performanceprobleme wegen fehlender Indices.
z.B.
EXPLAIN
SELECT feld1 FROM tabelle
WHERE id BETWEEN 1 AND 1000;
Grüße
Thomas
Subject
Views
Written By
Posted
2093
March 22, 2012 05:06AM
1056
March 22, 2012 05:37AM
934
March 22, 2012 06:48AM
Re: DEADLOCK Problem
944
March 22, 2012 08:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.