On 7/26/16, Richard Hipp <d...@sqlite.org> wrote: > Consider: > > SELECT * FROM t1 WHERE b=99 AND c<>22 ORDER BY a LIMIT 1; >
Or, how about this one: SELECT * FROM t1 WHERE appfunc(b)=99 AND c<>22 ORDER BY a LIMIT 1; In this case, SQLite has the option of doing a table look-up in order to evaluate c<>22 or calling a (possibly expensive) application-defined function "appfunc()" in order to evaluate the appfunc(b)=99 term. It is hard to know which to do first..... -- 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