concept few join in category sql
appears as: Fewer Joins, fewer joins

This is an excerpt from Manning's book SQL Server MVP Deep Dives Vol. 2.
Having fewer joins makes your queries more elegant, shorter, simpler, and in most cases, better performing. Here’s an example of a simple query from AdventureWorks, Microsoft’s sample database that was designed using artificial keys exclusively: