Home > IT Answers > Development > Difference Between “NOT IN” and “NOT EXISTS”
Goelneeraj
0 pts.
 Difference Between “NOT IN” and “NOT EXISTS”
SQL
Whats the difference between "NOT IN" and "NOT EXISTS" and which is better to use in SQL Queries for the performance aspects.

Software/Hardware used:
ASKED: August 29, 2005  1:19 AM
UPDATED: August 30, 2005  12:33 AM
RELATED QUESTIONS
Answer Wiki:
A correctly formatted NOT EXISTS query will execute very quickly in comparison to a NOT IN query because the the NOT IN query must make a full table scan.
Last Wiki Answer Submitted:  August 30, 2005  12:33 am  by  Robaan   0 pts.
All Answer Wiki Contributors:  Robaan   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _