INDEXED BY doesn't allow you to specify which index to use. It just causes the query to fail if SQLite thinks it should use an index different then the one specified by the INDEXED BY clause.
On Sun, Aug 16, 2009 at 7:59 PM, His Nerdship <shol...@hotmail.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
