"Hick Gunter"
I use EXPLAIN to make sure that my virtual tables' xFilter methods get
called with the proper parameters.
I guess I'm a geek ;)
Geek. :-) I guess I am one too.
-----Ursprüngliche Nachricht-----
Von: Simon Slavin [mailto:slav...@bigfraud.org]
Gesendet: Freitag, 15. November 2013 18:08
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] EXPLAIN QUERY PLAN
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.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--------------------------------------------------------------------------
Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at
This e-mail is confidential and may well also be legally privileged. If
you have received it in error, you are on notice as to its status and
accordingly please notify us immediately by reply e-mail and then delete
this message from your system. Please do not copy it or use it for any
purposes, or disclose its contents to any person as to do so could be a
breach of confidence. Thank you for your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users