Tag Archives: OUTER JOIN

Should I use OUTER JOIN instead of NOT EXISTS?

Posted on March 23, 2010 by Amit Singh

NOT EXISTS in a query can readily be replaced by an OUTER JOIN. Here is how This is because of the fact that in an LEFT OUTER JOIN every row in the left table is represented in the result set, … Continue reading →

Posted in Programming, SQL | Tagged Execution time, Instead, NOT EXISTS, OUTER JOIN, Performance, Query, SELECT, SQL, SQL Server, SQL Server 2005, SQL Server 2008 | Leave a comment

Tag Archives: OUTER JOIN

Should I use OUTER JOIN instead of NOT EXISTS?

Recent Posts

Categories

Archives