At best, you'll only get partial optimization. See http://www.craigberntson.com/Articles/kb004.htm


>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