>I am having a problem selecting data for a table. It takes too long.
>
>The table has about 60,000 records in it. Is there a way to speed up the SQL Select statement without using SQL server?
>
>This is the syntax...
>
>SELECT * FROM &_table WHERE ALLT(LCTRANSNUM) == ALLT(MATRELEASE) AND LCCURRUSER == ALLT(NAME) ;
>INTO CURSOR DATASET
>
>
>Adam
Adam,
Supposing you have an index on MATRELEASE and NAME
try
LCTRANSNUM = padr(LCTRANSNUM, tothefieldlength)
LCTRANSNUM = padr(LCCURRUSER, tothefieldlength )
SELECT * ;
FROM &_table ;
INTO CURSOR DATASET ;
WHERE ( MATRELEASE == LCTRANSNUM ) ;
AND ( NAME == LCCURRUSER )
Gregory