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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

BI DWH BALA avatar image BI DWH BALA commented ·
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.