The best replacement for union all is union.

The best alternatives to union all are rated as following:
★★★★★  union
★★★  union sql
★★  full outer join
★★  merge
★★  union access
★★  merge ssis
★  union oracle
★  multiple inserts
★  union in oracle
★  union performance
  union which is faster
  merge join

Your alternative for union all is not listed? Suggest!
Speaking about union all, one probably shouldn't forget about order by.

Other search terms related to union all and their ratings are:
★★★★★ order by
★★★ cte
★ order by in sql
You have in mind a companion for union all and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of union all in all years. Click on graph for more.
union all
union
union sql