On 23 Oct 2018, at 11:45pm, Hamesh Shah <ham...@evorta.com> wrote: > CREATE INDEX `detected_model_id_confidence_ts` ON `detected` ( > `model_id`, > `confidence` ASC, > `ts` ASC > );
Create another index with the fields in this order > `model_id` ASC, > `ts` ASC, > `confidence` ASC and try it again. By the way, avoid using those ` quotes (andh anything else like []) in any SQL command if you did not use them when you created the fields in the first place. In this particular case they'll work, but it's a bad habit to get into if you ever expect to use a different SQL engine. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
