SQLite version 3.14.0 2016-07-26 04:49:43
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table t(x,y,z);
sqlite> create index i1 on t(x,y);
sqlite> explain query plan select * from t where y=100 order by x desc;
0|0|0|SCAN TABLE t USING INDEX i1
sqlite> explain query plan select * from t where y=100 order by x desc limit 1;
0|0|0|SCAN TABLE t
0|0|0|USE TEMP B-TREE FOR ORDER BY
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
