SQL Server Performance Forum – Threads Archive
Difference between In and Multiple ORs
Hi, How the In clause Works. I read somewhere it uses temp tables.. Is it True? If I use multiple ORs instead of In, which is better performancewise ThanksIN is the same as a chain of ORs. You can look at execution plans to see.
Yes, IN is a shortcut to multiple ORs. Check out this explanation by Itzik Ben-Gan:
http://groups.google.de/group/microsoft.public.sqlserver.programming/msg/f530df34d5afe639 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Thanks for the information. I want to know which is better performancewise In or multiple ORs
>>I want to know which is better performancewise In or multiple ORs Set the execution plan and see Madhivanan Failing to plan is Planning to fail
]]>