Hacker News new | ask | show | jobs
by donatj 822 days ago
We have a couple queries where using the correct index they'll take milliseconds, using the wrong index it'll take minutes - and mysql occasionally enough to be a noticeable load on the database chooses the wrong one and we've specified "USE INDEX" even though I really hate having to do so.
1 comments

I'm curious about the query and schema that you're using