"Simon Slavin" wrote...
On 15 Nov 2013, at 4:29pm, jose isaias cabrera <cabr...@wrc.xerox.com>
wrote:
Is there any place that explain each of this entries?
<http://www.sqlite.org/opcode.html>
However, don't feel you should understand them. They're for geeks only.
The output from EXPLAIN QUERY PLAN can be very useful for people trying to
optimize their code. The output from EXPLAIN is really just for
developers and geeks trying to understand SQLite itself. If you need the
output of EXPLAIN to explain why your code doesn't work, you have serious
problems.
So yes, use EXPLAIN QUERY PLAN if you think it helps. But use EXPLAIN
only if you have spare time.
Thanks, Simon.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users