Hmm, I got this: SQLite version 3.21.0 2017-10-15 22:16:25 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open test_db1 sqlite> CREATE TABLE t1(a PRIMARY KEY, b, c) WITHOUT ROWID; sqlite> WITH RECURSIVE ...> cnt(x) AS (VALUES(1000) UNION ALL SELECT x+1 FROM cnt WHERE x<2000) ...> INSERT INTO t1(a,b,c) SELECT x, x,x FROM cnt; sqlite> CREATE INDEX t1b ON t1(b); sqlite> ANALYZE; sqlite> EXPLAIN QUERY PLAN ...> SELECT * FROM t1 WHERE b BETWEEN 500 AND 2500; 0|0|0|SEARCH TABLE t1 USING INDEX t1b (b>? AND b<?) sqlite> EXPLAIN QUERY PLAN ...> SELECT * FROM t1 WHERE b BETWEEN 2900 AND 3000; 0|0|0|SEARCH TABLE t1 USING INDEX t1b (b>? AND b<?)
Am I doing something wrong? -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
