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
