On Wed, Aug 09, 2017 at 06:48:51PM +0000, Wout Mertens wrote: > sqlite> create table t(j json, s string); > sqlite> create index s on t(s); > sqlite> create index j on t(json_extract(j, '$.foo')); > sqlite> create index l on t(length(s));
In order for any of these indices to be covering indices you need to add all the columns of the table t to them: sqlite> create table t(j json, s string); sqlite> create index s on t(s, j); sqlite> create index j on t(json_extract(j, '$.foo'), j, s); sqlite> create index l on t(length(s), s, j); Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users