Hi, I am using derieved tables and using left outer join with other tables. Can any one tell me if Left outer joins are faster than inner joins
And let's not forget that OP is talking about a join involving a derived table. Indeed inner joins are usually faster than left joins, but if you need a left join (for "unmatched results") then an inner join will not give you the results that you need. If you are filtering on the "right" table in a left join, then indeed you should use an inner join instead, and you may get better performance.