Posted by Erland Sommarskog on 05/04/06 00:14

Beowulf (beowulf_is_not_here@hotmail.com) writes:
> I have the following function(s) that each joins an active record with
> it's most recent record in an audit trail table, to show differences.
> I've perused the execution plans for 2 versions of this function in QA
> and it seems to me that the two versions execute identically - that is,
> the addressing the sub-query of the WHERE clause with either IN or =
> results in the same execution plan.
>
> Does this seem plausible or did I misinterpret something in QA?

It seems very plausible.

I nevertheless prefer the version with =. But that is merely because
it's easier to read and understand.

--
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: Re: Date creation in SQL
• Thread view: Re: Selecting MAX (Date) - Performance Question

[Reply to this message]