Which is faster join
Posted
by Costa
on Stack Overflow
See other posts from Stack Overflow
or by Costa
Published on 2010-03-28T17:50:46Z
Indexed on
2010/03/28
17:53 UTC
Read the original article
Hit count: 115
tsql
|sql-server
Hi
Which is faster
SELECT * FROM X INNER JOIN Y ON x.Record_ID = y.ForignKey_NotIndexed_NotUnique
or
SELECT * FROM X INNER JOIN Y ON y.ForignKey_NotIndexed_NotUnique = x.Record_ID
© Stack Overflow or respective owner