1 There are two ways to speedup UNIONs in a MySQL database.
2 Duplicates must be removed and this is an efficient way for the MySQL engine to remove them.
3 Imagine with our example above the shirts have a design date, the year they were released.