Ah, thanks, that was the one and will give that a try. RBS
> > 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