Funny real thing or illusion?

Tweaking a query, I notice a query executed after I did an `explain query plan 
<query>`, executes faster than before it occured.

I checked multiple times in case it could be due to something else in the 
environment or due to since how long the SQLite connexion is opened, I can just 
see it's really always after an `explain query plan` it executes faster: 120ms 
compared to 200ms (averages).

I could go from 300ms to 200ms (still too much to me) using an appropriate 
index, and am inquisitive to know what is this side effect which I seem to 
witness, in order to make use of it explicitely.

Or is this an illusion due to something else? At least, I really feel to see a 
unexplainable correlation??

-- 
Yannick Duch?ne

Reply via email to