Is there any difference between NOT IN and NOT EXISTS functionally and performance wise?
Regards BI DWH BALA
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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.
No one has followed this question yet.
Update and Insert in a single statment?
What is a 2 Phase Commit ?
need alter the table to include Identity column.
Merging in some Oracle questions
How does one load multi-line records?