Hi Clemens, It works perfect and fast with a covering index!! (I didn't know this concept but after you mentioned it, read about it here: http://www.sqlite.org/queryplanner.html#covidx Perhaps also interesting for others to read about)
Thank you very much! Gunnar On 09/29/2015 09:33 AM, Clemens Ladisch wrote: > gunnar wrote: >> Perhaps someone knows a way how I can speed up the original query. > Did you try a covering index (add cb_seq_num to ordercallback_index3)? > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >