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.sql-server-performance.com/tuning_joins.asp —
Frank Kalis
Microsoft SQL Server MVP