On 21 Apr 2017, at 5:16pm, Kim Gräsman <kim.gras...@gmail.com> wrote:
> Could be. Would that show up in EXPLAIN somehow? You would find it easier to spot using EXPLAIN QUERY PLAN. 'scan' means it’s just looking through the entire table, but you’ll see mentions of indexes there. > The statement I've > had trouble with so far is an UPDATE of a 5-million-row table. Does it have a WHERE clause ? SQLite may decide to do ordering when you use WHERE or ORDER BY. If there is no convenience index then it will create a temporary one. There are ways to minimise this, using ANALYZE and creating permanent indexes, but it would probably be easier to start from your WHERE clause and which indexes you have already created. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
