nn6eumtr <nn6eu...@gmail.com> wrote: > And I did a query: > > select * from tmp where x = 9 > > Would sqlite know how to use the index to find records where x = 9? Or > would it opt for a scan instead?
Why not ask SQLite itself? In sqlite3 console, or your favorite SQLite management tool, run this query: EXPLAIN QUERY PLAN select * from tmp where x = 9; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
