On 6 Jul 2017, at 12:32pm, Dominique Devienne <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
