SELECT ... UNION ALL SELECT ... UNION ALL
are very suitable for parallelisation
The idea here is to perform each SELECT query in a separate thread and
join the results of the UNION in the main thread.
Copyright (c) 2000, 2013, Oracle Corporation and/or its affiliates. All rights reserved.