Yes, I have run ANALYZE.
On Thu, Jun 23, 2011 at 11:56 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jun 2011, at 7:20pm, Rense Corten wrote: > >> Here are the results of EXPLAIN QUERY PLAN SELECT n1, n2 FROM table1 >> Where n1 < n2 INTERSECT SELECT n2, n1 FROM table1 Where n2 < n1; >> >> 1|0|0|SCAN TABLE table1 (~437976176 rows) >> 2|0|0|SCAN TABLE table1 (~437976176 rows) >> 0|0|0|COMPOUND SUBQUERIES 1 AND 2 USING TEMP B-TREE (INTERSECT) > > Have you run ANALYZE ? > > http://www.sqlite.org/lang_analyze.html > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users