SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alternative to NOT IN clause

sk12345678Aug 19 2011 — edited Aug 22 2011

1) What are the alternatives for the below query for better performance
2) Does NOT IN for sub-query always give poor performance?

delete from T1
where (col1, col2)
NOT IN
( select col1, col2 from T2
union
select col1, col2 from T3
)

Thanks.

Edited by: rajugopalli on Aug 18, 2011 10:29 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2011

Added on Aug 19 2011

8 comments

5,549 views