>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
>

unless there is an existing index on LEFT(codes,1), left(codes,1) = '1' as not optimizable; either add an added tag, or use code = '1' and adjust the SET ANSI setting to match only up to the shorter expression, so that it becomes optimizable.

>The other selects select codes = 2 and then codes = 3.
>

Same suggestion.

>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?
>

SYS(14) handles returning the index expression of a tag or IDX style index.

>Thanks,
>Sunshine