On 7/15/16, Simon Slavin <slav...@bigfraud.org> wrote: > > 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
That shouldn't matter. If you find a case where it does, please report it as a bug. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
