On 2/2/2015 10:24 AM, Sairam Gaddam wrote:
Normally for executing joins in sqlite,the vdbe program opens 1 loop for each and every table
What makes you believe that?
but in my code(attached that file via pastebin) ,i am facing an issue because it is opening only 2 loops even if i use 4 tables in joining operation.
The relationship between em and lo is one-to-one. The engine is most likely looping over one, and looking up rows in the other by primary key. Same with idv and mny.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users