On 7/15/16, Simon Slavin <[email protected]> wrote: > > On 15 Jul 2016, at 1:45pm, Jain, Punit <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
