Have tried INDEXED BY and it does indeed work and force the use of the specified index. It didn't however make the query faster, so maybe the SQLite plan generator is better than I thought!
RBS On Thu, Sep 17, 2009 at 10:07 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > > On Sep 17, 2009, at 5:02 AM, Bart Smissaert wrote: > >> Is it possible to tell SQLite to use a specified index? >> I know you can use the + to excludes fields being used in an index, >> but this doesn't help me in this particular case. I remember a >> discussion about this and that this option might be added to SQLite, >> but couldn't find it anywhere. > > There is the "INDEXED BY" clause. But many are of the opinion that > this feature is prone to misuse. > > http://www.sqlite.org/lang_indexedby.html > > Dan. > >> >> RBS >> _______________________________________________ >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users