Performance Woes & Wows #5: IN vs UNION

Querying the Same Thing. Faster. In a previous post, we’ve seen that equivalent queries can produce distinct execution plans – Yes, how nice and intuitive of you SQL Server. But this happens for a logical reason: The Query Optimizer hates you doesn’t have the means to explore every possible semantic equivalence. Hence, the shape of … Continue reading Performance Woes & Wows #5: IN vs UNION

Follow My Blog

Get new content delivered directly to your inbox.