Use a merge with full output buffers. The system will accumulate all of the results before making any of them available to the consumer of the query.