The sqlite3_prepare() functions convert the SQL statement into an executable 
VDBE program. You can view the results in the Sqlite shell by typing:

.explain
explain <query>;

which will show the VDBE opcodes generated for the query (the .explain switches 
the output format to something suitable for explain).

 If you just want to know what the optimizer was thinking, use:

explain query plan <query>;

-----Ursprüngliche Nachricht-----
Von: Prakash Premkumar [mailto:prakash.p...@gmail.com]
Gesendet: Dienstag, 16. September 2014 07:53
An: sqlite-users@sqlite.org
Betreff: [sqlite] SQL Query to Vdbe Instructions

Hi,
Can you please tell me which function/set of functions convert the SQL query to 
Vdbe program ?

Thanks
Prakash
_______________________________________________
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
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This communication (including any attachments) is intended for the use of the 
intended recipient(s) only and may contain information that is confidential, 
privileged or legally protected. Any unauthorized use or dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please immediately notify the sender by return e-mail message and 
delete all copies of the original communication. Thank you for your cooperation.


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to