GB wrote: > 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.
"Error: no query solution" Rag_Idx1 index cannot be used because the collations do not match. (But this is a good way of checking your assumptions.) Regards, Clemens