Gerd, Thanks for this.
We?ll add this to the to-do list for the day. We?ve had a lot of responses back and we need to put a plan together to work through them one by one and see the impact, It?ll be an interesting day. Thank you for taking the time to look at our e-mail and replying Rob > On 3 Jul 2015, at 07:06, GB <gbinfo at web.de> wrote: > > > > Rob Willett schrieb am 03.07.2015 um 00:16: >> SCAN TABLE RAG USING COVERING INDEX Rag_Idx4 >> >> > > Since Rag_Idx4 is quite wide and not primarily ordered by "Text", an index > scan might not be significantly faster than a table scan. As already > mentioned, ANALYZE might help. > > For curiosity you may try to force it to use "Rag_Idx1" by executing > > "select Id,Calculation,Peak,Red,Amber,Green from RAG INDEXED BY Rag_Idx1 > where text = ?" > > and see if it makes any difference. If it does you may consider rearranging > Rag_Idx4. > > > hth > Gerd > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
