"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
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.
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|
3 matches
Mail list logo