> deconstruct our request into a few simple queries Makes sense if you can cache only portions of the result, and/or the query optimizer or database layout act

> deconstruct our request into a few simple queries Makes sense if you can cache only portions of the result, and/or the query optimizer or database layout actually struggle with the join.