left outer join and rules | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

left outer join and rules

Is there any rules that we should follow when doing a left outer join? I’m getting mixed results when I swap the table in the query. Should left table always have more rows than the right table?
maybe this link’s explanation can help:
http://www.devx.com/dbzone/Article/17403/0/page/4
http://www.sql-server-performance.com/tuning_joins.asp —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
]]>