On 7/26/16, Richard Hipp <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
