Reputation
Next privilege 125 Rep.
Vote down
Badges
1
Newest
 Supporter
Impact
0 people reached

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?