Jain, Punit wrote: > Since we are performing a join on a column name of a table, we cannot > give a fixed value.
In a nested loop join, the database simply goes through one table, and for each row, searches the matching rows in the other table. Your virtual table module must optimize that search for the matching rows, using a _single_ value. Non-virtual joins work the same way: sqlite> explain query plan select * from t2 join t1 using (name); 0|0|1|SCAN TABLE t2 0|1|0|SEARCH TABLE t1 USING INDEX t1_name (name=?) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
