> On Aug 16, 2017, at 8:36 PM, jose isaias cabrera <jic...@barrioinvi.net> > wrote: > > The following query is taking a bit too long for my taste. I did a quick > query with explain and I got this…
The output of EXPLAIN QUERY PLAN is a lot easier to understand; have you tried that? Most importantly it shows which indexes / tables are being searched (fast) or scanned (slow), and if a covering index is used. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
