Hi,

One of our query to update 2 tables hangs indefinitely after data purge was done. Any idea?

Query is something like

select t1.*, t2.*
from t1 for update, t2 for update
where t1._index1 inrange {:a} and {:b}
and (t1.c = AA or
t1.c = BB or
t1.c = CC)
and t2._index1 = {t1.d}
and t2.e = DD
and not exists
(select t3.i
from t3
where t3._index1 = {t1.f}
and t3.epor.w = t1.g
and t3.eppo.w = t2.h)

Thank U.

why do you not try to make the updates in two different sql-statements?
I'm wondering, if the update of two tables in one sql-statement is even possible :confused:.