> On Oct 26, 2017, at 6:11 AM, Richard Hipp <d...@sqlite.org> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users