Performance: OR vs IN

What’s Faster: IN or OR? ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ Hello Everyone, I want to share a tweet I posted earlier, which received an incredible response about SQL performance. Some responses were correct, some were not so clear, a few seemed lost, and some were just generally unhappy. The tweet was titled, "[Which of the following will provide better performance? #SQL #SQLServer.](" Whenever I noticed users were unclear about the concept, I encouraged them to try out the sample and provided a sample in my initial tweet response. Additionally, I wrote a follow-up blog post, which you can find here: "[SQL SERVER – Performance: OR vs IN.](" However, the highlight of this entire effort was a fantastic response from none other than Brent Ozar, our friendly SQL expert. He wrote an amazing blog post that was truly mind-expanding (in a positive way), if I may use that term. Just by reading his blog post, I felt enlightened, and I strongly encourage all of you to give it a read: "[What’s Faster: IN or OR? Columnstore Edition.](" Brent has a remarkable way of explaining even the simplest concepts in the most straightforward manner. Please feel free to engage with any of the links mentioned above. I'm sure you'll want to join in on the fun! Best regards, Pinal @ SQLAuthority.com To make sure you keep getting these emails, please add pinal@sqlauthority.com to your address book or whitelist us. Want out of the loop? [Unsubscribe](. Our postal address: M.G. Road, Bangalore. India