Hi,
is there a way to speed up a delete operation that currently uses a „where XX in” clause?
The following query takes quite long:
delete from lr_object_usage where lr_object_usage_id in (
select lr_object_usage_id from lr_locked_objects where timeout_time < now() and context is not null
);
to get the rows I want to delete into a select query I can simply use
select * from lr_object_usage lrou inner join lr_locked_objects llo
on llo.lr_object_usage_id = lrou.lr_object_usage_id
where llo.timeout_time < now() ;
But how can i rephrase the delete operation to get a fast delete operation? I tried also to use “exists” instead of “in” but that did not help either.
Many TIA,
peter
