© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
Interesting... I was unaware of the FORCE INDEX clause in MySQL. I'm not sure how much upstream will take a liking to that (the use of it would minimally have to be guarded for MySQL dialects, as things like postgres and other SQL servers don't support it AFAIK).
Similar to my last post on the subquery and changing it from a LEFT OUTER JOIN to INNER JOIN + UNION, we got along by refactoring the generated query such that the optimizer could leverage the index.