> On Oct 26, 2017, at 6:11 AM, Richard Hipp <[email protected]> wrote: > >> Is this an optimization opportunity for calculated indexes? > > It is. There is a min/max optimization to deal with this situation, > but it currently does not know about indexes on expressions.
+1. The project I work on (Couchbase Lite 2) also uses indexes on expressions and would benefit from this min/max optimization. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
