SQL Server Developer Center >
SQL Server Forums
>
SQL Server Data Warehousing
>
Difference in exits and inlist
Difference in exits and inlist
- Hi,
Tell me the difference between using exists and using in list in queries. Which one will work faster?
Answers
- ____ manjil44,
in common an EXISTS query has a better performance the a IN () query.
But both are solve into a JOIN operation; the say what is better you have to take a look at the execution plan of the queries.
Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de- Marked As Answer byCharles Wang - MSFTMSFT, ModeratorTuesday, October 27, 2009 4:32 AM
All Replies
- ____ manjil44,
in common an EXISTS query has a better performance the a IN () query.
But both are solve into a JOIN operation; the say what is better you have to take a look at the execution plan of the queries.
Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de- Marked As Answer byCharles Wang - MSFTMSFT, ModeratorTuesday, October 27, 2009 4:32 AM
