How to Optimize MySQL UNION For High Speed

Join 38000 others and follow Sean Hull on twitter @hullsean. There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions. By the way, I write an article like this every month, covering consulting lessons, tech trends, cloud and …