On 30 Jan 2016, at 4:55pm, Yannick Duch?ne <yannick_duchene at yahoo.fr> wrote:
> Tweaking a query, I notice a query executed after I did an `explain query > plan <query>`, executes faster than before it occured. Computer reads data from disk when you do the "EXPLAIN QUERY PLAN". Data still in cache when you run the real SELECT. To see something similar run the same SELECT twice. > I could go from 300ms to 200ms (still too much to me) using an appropriate > index You may be able to improve it further using a better index, better COLLATEs, or a better schema. We're happy to help you. Simon.
