On 4/4/2011 2:05 AM, Guilherme Bamepe wrote: > Hi! > > I'm new in SQLite, and I'm studying it to do a work in my college, > and would be helpful if I get the SQLite to print, while executing > the sql, after each table scan or join, the name of the table and > number of rows that are going to the next operator... for example.. > the following sql: select * from student join college on student.id > = college.id where student.age = 20; would print: After table > student scan - rows = 2324; After 1st join - rows = 200; Have you tried "explain query plan" http://www.sqlite.org/lang_explain.html or the trace api: http://www.sqlite.org/c3ref/profile.html ?
thilo > > Is there anything like this in sqlite that I could use? If not, is > it too difficult change the code? Could anyone give me some simple > code examples? > > > Thanks!! > > > > _______________________________________________ sqlite-users > mailing list [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Dipl. Ing. Thilo Jeremias Zur Rabenwiese 14 27239 Twistringen T: +49 15782492240 T: +49 4243941633
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
