101 reputation
1
bio website
location
age
visits member for 1 year, 6 months
seen Apr 6 '13 at 21:52

Jan
3
awarded  Supporter
Jan
3
comment MySQL: Optimize UNION with “ORDER BY” in inner queries
@ypercube, +1 this is very clever and worked in my (similar) situation too! Can you explain why wrapping the unioned queries in a dummy SELECT * FROM tricks MySQL into using the indexes?