Jain, Punit wrote: > We have implemented virtual tables > > E.g. a query such as "select * from t1 join t2 on t1.name=t2.name" > > We tried to optimize it using xBestIndex and xFilter but to no avail. > We couldn't find a way to pass the value of t1.name (for each row) > to the filter of t2.
SQLite uses nested loop joins. You have to support lookups of the form "t1.name = <fixed value>" or "t2.name = <fixed value>". Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
