On 14 Jan 2013, at 2:30pm, Selen Schabenberger <[email protected]> wrote:
> As far as I know, the index (column1, column2, column3) is more useful than > the index (column1). Why does the analyzer not like the concatened index for > that query? Did I misunderstand the whole idea with the multi-column indexes? You can get clues about what indexes will be used using the 'EXPLAIN QUERY PLAN' command: <http://www.sqlite.org/eqp.html> Just out of interest, with the same setup and the data you describe in your question already entered, execute the SQL command 'ANALYZE' and then do your SELECTS again. See if SQLite chooses the same strategies. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
