well for ad-hoc examination it was much better to leave off the order-by and remember that the results had sub-sections in nondeterministic order.

otherwise the answer is the typical "it depends" - on tradeoff between sorting a huge flat resultset and the time it takes to select each part with multiple CPU.