Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL speed issue
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL speed issue
Divers
Thread ID:
00468019
Message ID:
00468019
Vues:
60
Here's the statement:

SELECT Base_Payment.PIN, ;
Base_Payment.Payment_Key ;
FROM Base_Payment ;
WHERE Base_Payment.Payment_Key = 10348 ;
INTO CURSOR ;
C_SomeCursor

466 Celeron, 128 Ram, Win98, VFP 6.0 SP3

There are 5 indexes, 3 on dates, one for PIN (Primary) and
one for the Payment_Key. PIN and Payment_Key are integers.
The above statement will return 36 records, but it takes
a WHOPPING 141 seconds to do so. I know this isn't right
or at least I wouldn't think so. OPTIMIZE is ON and I've
deleted and recreated the indexes.

What's wrong with this picture?

Thanks,
Steve
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform