Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I optimize this query?
Message
De
30/01/2005 15:02:59
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00982000
Message ID:
00982104
Vues:
48
>Fabio, Thanks for Your will to help. But as I understood (hard way) I am not so clever that I thought :o))))
>If You are interested look at Message #982019. Sorry for bothering you

No problem, but you written that this select have to return 8 records from the Results table.
With 22K records into the outer table, the expected time for your select is max 100ms.

Fabio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform