On 6 Jul 2017, at 12:32pm, Dominique Devienne <ddevie...@gmail.com> wrote:
> Actually not that much apparently. > No Simon, I didn't have an index on code_type. > In fact keys is itself a view, and cote_type a case expression. The index you created is not helpful. It is not useful for what you’re doing. I suggest you remove the VIEW layer from your layered query, then reconsider what indexes might be helpful. We can advise you on indexes if you post the resulting query. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
