Howard Kapustein wrote: >> you might have to change the query itself > > The question is how?
The database has estimated that even with the cost of creating the temporary index, this way is the fastest. So it's unlikely that there is another way that would be an improvement. Anyway, try using the CTE on the left side of a CROSS JOIN to force the DB to use it as the outer table of the nested loop: http://www.sqlite.org/lang_select.html#crossjoin > Right now my log's being spammed with oodles of automatic index > messages because of the CTE. You could disabling logging for this query, or filter out these specific messages. Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
