Re: [sqlite] SQLite - Explain

2009-01-28 Thread Igor Tandetnik
"Rogério Costa" wrote in message news:3dd03f9d93e74caebaace23a9c3cc...@rochico > Does any one know what means each of the values that are presented as > a result of a EXPLAIN command? http://sqlite.org/opcode.html http://sqlite.org/vdbe.html Igor Tandetnik

Re: [sqlite] SQLite - Explain

2009-01-28 Thread Mihai Limbasan
Hi, Rogério. Depending on exactly what info you want, you might be looking for the EXPLAIN QUERY PLAN statement, as in: EXPLAIN QUERY PLAN SELECT * FROM a; or, if you want to understand what the VDBE commands you're seeing there mean, you will have to look at the source, namely vdbe.c.

[sqlite] SQLite - Explain

2009-01-28 Thread Rogério Costa
Hi, Does any one know what means each of the values that are presented as a result of a EXPLAIN command? Is there anything like an "query execution cost"? Thanks 0|Trace|0|0|0|explain select * from a;|00| 1|Goto|0|10|0||00| 2|SetNumColumns|0|1|0||00| 3|OpenRead|0|2|0||00|