I have a query (with a where clause ) which returns the same number of records using INNER JOIN and LEFT OUTER JOIN .
My collegue told me that the left outer join is slow compared to inner join even when the results sets are the same , after executing I found out that the query executes in 0.7 sec in both the cases.
I know the difference between left join and inner join , but i would like to understand during a WHERE clause condition how both the queries are executed .
Will the left outer join do more work/time compared to the inner join ?