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.
Hope this helps.
Mihai Limbasan
Rogério Costa wrote:
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|
4|Rewind|0|8|0||00|
5|Column|0|0|1||00|
6|ResultRow|1|1|0||00|
7|Next|0|5|0||01|
8|Close|0|0|0||00|
9|Halt|0|0|0||00|
10|Transaction|0|0|0||00|
11|VerifyCookie|0|1|0||00|
12|TableLock|0|2|0|a|00|
_______________________________________________
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
