On 15 Jul 2016, at 1:45pm, Jain, Punit <punit.j...@emc.com> wrote: > Clemens, thanks for the response. Since we are performing a join on a column > name of a table, we cannot give a fixed value. Is there any other way to > optimize join operations?
Are both tables virtual or just one ? Instead of select * from t1 join t2 on t1.name=t2.name you could try this instead: select * from t1 join t2 on t2.name=t1.name Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
