Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement