Hi! I believed that databases in general evaluate their queries, following a execution plan... e.g. first do a table scan and apply a filter from the where clause.. than use the results to execute a join with other table.. than use the results to excute with another join..
but now, from what I've seen, sqlite just does a nested loop, and returns (if available) a row in each loop... This type of execution is specific from sqlite, or there are more databases that use the same algorithm? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
