Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select is slow in large tables
Message
De
19/06/1998 12:18:00
David Frankenbach
Austin, Texas, États-Unis
 
 
À
19/06/1998 11:28:40
Bernard Bout
Zest
Brisbane, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: SQL select is slow in large tables
Divers
Thread ID:
00109911
Message ID:
00109948
Vues:
48
Bernard,

Is SET DELETED ON? if it is do you have an index: INDEX ON DELETED() TAG DELETED?

>There is an index on inv_number and even if I do a select as so
>
>SELECT * from inv_table WHERE BETWEEN(inv_number,20000,60000) into...
>
>it is still sloooow!
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform