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.
Heavy MDX Query
How to check bottlenecks in a query with respect to performance?
What is Pragma Init Exception in oracle?
Archive log over 300GB DB never backed up
Define a method to group records by a field referenced from other tables