...(inner) joining 10 huge (well designed) tables by (tunned) indexed columns ill run smoothly.
Until you have some data value skew, in which case the probability of getting screwed increases with increasing numbers of joins
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service