Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Speed
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Speed
Miscellaneous
Thread ID:
00877901
Message ID:
00877901
Views:
43
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
Next
Reply
Map
View

Click here to load this message in the networking platform