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 <[email protected]> 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 >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
