Hi Pavel, > Does INDEXED BY clause work for you? > http://www.sqlite.org/lang_select.html
The page suggests that INDEXED BY can only be used in single-table queries. The report queries also join other smaller tables, some of them from an attached database, so I don't think this will work. However, you have given me an idea - maybe I could break it down to two queries. Use the INDEX BY on the big table to get a subset table, and do another SELECT on the subset. Thanks. Sholto (His Nerdship) > Is there any way the code can 'suggest' SQLite use a certain index? Pavel -- View this message in context: http://www.nabble.com/Multiple-indexes-in-SQLite%2C-and-selecting-which-to-use-tp24981846p24999340.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users