On 4 Apr 2011, at 11:53am, thilo wrote: > 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 ?
Are you trying to dissect the inner workings of SQLite in a way that's specific to SQLite, or do you simply want to know information about your data ? How would you expect to get the details when a SELECT has multiple JOINs, and what would you do with the information if you could get it ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
