Posted by Erland Sommarskog on 05/06/06 00:16

Beowulf (beowulf_is_not_here@hotmail.com) writes:
> So, the SQL Server query optimizer is smart enough to figure out that
> the sub-query in the WHERE clause will return only a single value and is
> able to figure out that WHERE x IN (a) is the same as WHERE x = a.
> That's pretty cool.

That's a fairly trivial exercise for the optimizer, I'd say. :-)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Problem with using BETWEEN for date range...
• Prev in forum: Help with update trigger
• Thread view: Re: Selecting MAX (Date) - Performance Question

[Reply to this message]