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

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

瀏覽:1079
日期:2026-04-22
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 ......看更多