INNER JOIN vs LEFT JOIN performance in SQL Server
Posted
by Ekkapop
on Stack Overflow
See other posts from Stack Overflow
or by Ekkapop
Published on 2010-04-28T03:36:03Z
Indexed on
2010/04/28
3:43 UTC
Read the original article
Hit count: 352
I've created SQL command that use INNER JOIN for 9 tables, anyway this command take a very long time (more than five minutes). So my folk suggest me to change INNER JOIN to LEFT JOIN because the performance of LEFT JOIN is better, at first time its despite what I know. After I changed, the speed of query is significantly improve.
I want to know why LEFT JOIN is faster than INNER JOIN?
My SQL command look like below:
SELECT * FROM A INNER JOIN B ON ... INNER JOIN C ON ... INNER JOIN D and so no
© Stack Overflow or respective owner
