• GilaMonster (3/7/2013)


    Dung Dinh (3/7/2013)


    2 - If both are big, you should use second solution and index the columns on ON clause

    Not true.

    I mean that the second is preferred in this case. Of course, If we would like to be sure, we need to record performance on both of IN and INNER JOIN base on your environment.

    In my case, I often select INNER JOIN as the first while working with large tables and check indexes. After that, record performance to compare.