MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to speed up query on a table with over 20million records?
Posted by: Peter Brawley
Date: March 25, 2018 10:03PM

> could you check the second query I posted, the index should be right.

Nothing stands out to me in the trace for the 2nd query. I populated your 2nd table with 100k rows, as one would expect Explain says it likes the PK, the query ran in a quarter of a second on an old box running 5.7. If I were you I'd try the query on a local copy of the table.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.