On 3 Feb 2019, at 9:52am, Gerlando Falauto <gerlando.fala...@gmail.com> wrote:
> I do want them sorted, and I also want the whole (huge) dataset to be > processable without having to store it all in memory or temp files. > Sounds like the whole purpose of an index, doesn't it? > I do know SQL is all about the result, not how it's obtained, though. Absolutely. You should be fine. Try using the procedure in my previous message (the one which mentions ANALYZE) to find out the most useful index. Once you've found that, you can delete the other index. Then you've solved the problem and can move on. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
