EXISTS Versus IN

#1

Is there any performance differences between the use of EXISTS and IN within
queries?

#2

Yep.

Exists stops when it finds the value and IN just ploughs on.

Have a look here

http://www.sql-server-performance.co..._sql_where.asp

"Robert Hamilton" <RobertHamilton (AT) discussions (DOT) microsoft.com> wrote in
message news:RobertHamilton (AT) discussions (DOT) microsoft.com:

Quote:

Is there any performance differences between the use of EXISTS and IN within
queries?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

EXISTS Versus IN

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

EXISTS Versus IN - 05-19-2005 , 01:16 PM

Re: EXISTS Versus IN - 05-19-2005 , 01:52 PM