Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up my query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01034597
Message ID:
01034619
Vues:
18
>
>If you just use SELECT - SQL there is no need to set order, recommendation for Rushmore Optimization is the table not to have order. But if you want just want to SEEK you need to point the order, no metter how, If you don't the current order is used.
>:o)
>I don't know if you uderstand something from this explanation, I hardly understand myself :o)))
>Check Using Rushmore Query Optimization to Speed Data Access in HELP for more valuable info.

A SELECT - SQL doesn't use already open tables so it's irrelevant if they have order set or not.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform