Update query takes too long time
Posted by:
Vi Ra
Date: January 10, 2025 08:55AM
UPDATE belegkopf SET lieferdatumist=(SELECT erstelltam FROM vorgang WHERE KEY1=belegnr) WHERE ISNULL(i4) LIMIT 5;
Limit = 1 it takes 0,15 sec
Limit = 2 it takes 6,2 sec
Limit = 5 it takes 22 sec
What is worong with my update ?
Subject
Written By
Posted
Update query takes too long time
January 10, 2025 08:55AM
Sorry, only registered users may post in this forum.
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.