"When you hit 10 joins, you should contemplate your life choices. By the time you hit 15 joins, you've just entered the realm of no return." - Me when I find out that a query I've got a ticket for(because it's taking too long) has 18 joins to tables with no indexing at all.