question

BI DWH BALA avatar image
BI DWH BALA asked

Difference between NOT IN and NOT EXISTS?

Hi,

Is there any difference between NOT IN and NOT EXISTS functionally and performance wise?

Regards BI DWH BALA

oracle
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Christian13467 avatar image
Christian13467 answered

Found some places with good explanations:

Functional difference between NOT IN vs NOT EXISTS clauses
Understand how NULLs affect IN and EXISTS

Read there, I cant explain it better.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you Christian. The documents are pretty good.!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.