Eric Grange wrote: >> Add the LEFT JOIN strength reduction optimization that converts a LEFT >> JOIN into an ordinary JOIN > > A question on this one: I have been using LEFT JOIN for many years (and not > juste in SQLIte) in cases where a JOIN could have been used as a way to > "hint" query optimizers which tables to scan first. > > Is there a planned "QUERY PLAN" or lightweight hinting is in the works?
No, because it's already there: http://www.sqlite.org/lang_select.html#crossjoin Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
