Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Speed
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Speed
Divers
Thread ID:
00877901
Message ID:
00877901
Vues:
45
Is there anyway I can speed the following SQL statement up?
SET TALK ON
SELECT modacad.mainkey as mainkey, specific.no_in_row as specific, article.descrip1 as group, artichk.achkpoint as element, artichk.extrac1 as weight, ;
modacad.key1 as key1, modacad.key2 as key2, modacad.key3 as key3, modacad.key4 as key4, modacad.moc042 as moc042, modacad.moc011 as moc011;
FROM "U:\Questpdm\Data\modacad.dbf", "U:\Questpdm\Data\specific.dbf", "U:\Questpdm\Data\article.dbf", ;
"U:\Questpdm\Data\artichk.dbf" ;
WHERE specific.mainkey=modacad.mainkey and specific.artikey=article.artikey and specific.packing=.T. ;
AND article.artikey=artichk.artikey and  modacad.mainkey="T56*SS2004*NEIL001*SAMPLE" ;
ORDER BY specific.no_in_row, artichk.achkpoint;
INTO table fablin
SET TALK OFF
It is taking a little long to produce and I thought there maybe some changes I could do to improve it.

Many Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform