Background: If I have a main table and many other foreign tables containing optional/sparse related information, one must do a LEFT JOIN to select the main and option data.
I've heard/read that LEFT JOINs are less efficient/slower than INNER JOINs. Googling isn't turning up much info. Is this true?
If they are slower, is there an alternative to using LEFT JOINs in the scenario above? (main table + many optional foreign tables containing sparse info).
Extreme case: If I have a main table and, say, at an extreme, fifteen (15) other related tables? Wouldn't doing 15 LEFT JOINs bring SQL Server 2005 to it's knees?