Hi Sunshine,
PMFJI, SYS(14,1) will return the first index--SYS(14,2) the second and so on.
I would be sure you have index expressions on rca and one on exp_date. Codes isn't as important.


>1) what version of VFP?
>Running 2.6 for DOS
>
>2) What OS?
>Win 98
>
>3) What RAM on the machine running so slow?
>Virtually no RAM on my computer left (waiting on a new one hopefully).
>The person who runs this program daily has a new DELL with 256.
>
>4) Can you show us the Select statements that are running so slow?
>
>select name as name, address as address, alltrim(city) + ' ' + alltrim(zip) as city;
>from rchld;
>where (rca = 'ATL' .or. rca = 'NAT');
> .and. exp_date >= date();
> .and. left(codes,1) = '1';
>into table temp;
>order by name
>
>The other selects select codes = 2 and then codes = 3.
>
>This table has 4 indexs and I'm not sure how to tell if one indexes the name field. How can I tell what an index indexes?
>
>Thanks,
>Sunshine