In this Quick Tip, Aaron Bertrand and Kevin Kline discuss queries that use IN(...) vs. queries that use OR. They use a demo to show how the two types of queries optimize to the exact same plan.
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
