SQL Server Performance Forum – Threads Archive
Difference between In and Multiple ORsHi, 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 Thanks
IN 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:
Microsoft SQL Server MVP
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