SET EXACT OFF
SELECT * from Wotran01 where wono+STR(tranlineno,4,0) = lcWo into cursor CopyWO
>
>I've got a pretty serious performance issue with an accounting app (AccPac Manufacturing) utility.
>
>I need to query all transaction records for a given work order.
>
>Very simple example:
>
>SELECT * from Wotran01 where wono = lcWo into cursor CopyWO
>
>The problem is that there is no index specifically on wono and with several million records it is dead slow.
>
>There is however an index with the following structure: wono+STR(tranlineno,4,0)
>
>Because of the size of the table I'd rather not have to make an index specifically on wono unless it is abolutely necessary.
>
>So... Is there a way to query these transaction records so that I can get all the records for a cooresponding work order and ignore the tranlineno in the file but still get the benefit from the exiting compound index???
>
--sb--