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: 117

Filed under:
|

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

Related posts about tsql

Related posts about sql-server