As with subqueries, UNION statements can create a heavy load on your database server, but for occasional use, they can save a lot of time. When to use SELECT, JOIN, UNION or subqueries ...