concept few join in category sql

appears as: Fewer Joins, fewer joins
SQL Server MVP Deep Dives Vol. 2

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: