>I replaced my LEFT OUTER JOIN with INNER JOIN, and the query took only 8 seconds this time.
>
>LEFT JOIN can always be replaced with INNER JOIN and a UNION. Did both INNER JOINS table1->table2 and table2->table1 work the same?


I'm not sure, but that comment doesn't ring true to me. Can you provide an example test to show me what you mean?