Difference Between “NOT IN” and “NOT EXISTS”
Home > IT Answers > Development > Difference Between "NOT IN" and "NOT EXISTS"
goelneeraj
0 pts.
0
Q:
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.
ASKED: Aug 29 2005  1:19 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
robaan
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Aug 30 2005  0:33 AM GMT by robaan   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0