Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Greetings,
>
>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+STR(tranlineno,4,0) = 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???
>
>Thanks in advance!
Previous
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