General information
Title:
Help Improving Select Speed
Hello,
Is there a good way to search a character field for
the occurance of a string?
Currently I am using the following but it is very slow.
I do have CDX indexes on both of the fields and tried
with the order set and with no order.
SearchMe = "TEST"
Select item_no, item_desc from datafile;
Where ATCC(SearchMe, upper(item_desc))<> 0;
order by item_no nowait into cursor Find
Thanks in Advance for your help.
Jeff
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only