sql - LEFT INNER JOIN vs. LEFT OUTER JOIN - Why does the OUTER take longer? - Stack Overflow

We have the query below. Using a LEFT OUTER join takes 9 seconds to execute. Changing the LEFT OUTER to an LEFT INNER reduces the execution time to 2 seconds, and the same number of rows are return... ... 1) in a query window in SQL Server ...

stackoverflow.com