|
|
Posted by Erland Sommarskog on 11/28/78 11:56
David Portas (REMOVE_BEFORE_REPLYING_dportas@acm.org) writes:
> In cases where an inner and outer join are guaranteed to give the same
> result I suggest you test it out for yourself.
And in that case, I expect the optimizer to see that the left join is
really an inner join, and thus you would get the same query plan.
The question is simply not meaningful, since, as David pointed, the
difference lies in functionality.
--
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
Navigation:
[Reply to this message]
|