Re: optimizing in delete-statement

Hard to give any advice with the kind of info you provided to us, but assuming that you use CBO and have an index on tUserXorganizer(ItemId), try:

DELETE FROM tRoute
WHERE exists
(
SELECT /*+ hash_sj */ 1
FROM tUserXorganizer
WHERE tRoute.RouteId = ItemId AND Type = :1 AND FKUserId = :2 )
;

Daniel Received on Fri Feb 07 2003 - 18:26:28 CST