> Querying a single table with an indexed key will be faster as a single lookup than doing a JOIN, let alone several.

Not always, particularly when you're returning multiple keys at once. Some comparisons with column stores would be instructive.