>>>Then, without FORCE uses derivate subquery to force the STEP BY STEP good order:
>>>

>>>select cTrans_pk, step1.cUsGrlink_pk ;
>>>	from Trans;
>>>         inner join ;
>>>           (SELECT TEQ.cTrans_fk,cCommission_Owner_UsGrLink_fk as cUsGrlink_pk   FROM Employee_Queue_Schedules EQS ;
>>>              inner join Trans_Employees_Queues TEQ;
>>>                    on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk
>>>              WHERE EQS.iActive_Flag = 1 and EQS.tScheduled_time < {^2006-05-03 00:00:00};
>>>                 AND TEQ.iActive_flag = 1) step1 ;
>>>         on Trans.cTrans_pk = step1.cTrans_fk ;
>>>    where Trans.cResolution_Codes_fk is Null
>>>
>>>

>>>
>>3 seconds after re-loading VFP
>>
>>select cTrans_pk, step1.cUsGrlink_pk from Trans inner join (SELECT TEQ.cTrans_fk,cCommission_Owner_UsGrLink_fk as cUsGrlink_pk FROM Employee_Queue_Schedules EQS inner join Trans_Employees_Queues TEQ on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk WHERE EQS.iActive_Flag = 1 and EQS.tScheduled_time < {^2006-05-03 00:00:00} AND TEQ.iActive_flag = 1) step1 on Trans.cTrans_pk = step1.cTrans_fk where Trans.cResolution_Codes_fk is Null into cursor curTest
>>Using index tag Tschedtime to rushmore optimize table eqs
>>Rushmore optimization level for table eqs: partial
>>Rushmore optimization level for table teq: none
>>Joining table eqs and table teq using index tag Cempque_pk
>>Using index tag Crescod_fk to rushmore optimize table trans
>>Rushmore optimization level for table trans: full
>>Rushmore optimization level for intermediate result: none
>>Joining intermediate result and table trans using index tag Ctrans_pk
>>
>>
>>
>>
>>>with FORCE EXIST A WORKAROUND
>>>VFP optimize where conditions into the ON clause
>>>

>>>select cTrans_pk, cCommission_Owner_UsGrLink_fk as cUsGrlink_pk ;
>>>    from FORCE Employee_Queue_Schedules EQS ;
>>>      inner join Trans_Employees_Queues TEQ on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ;
>>>         AND EQS.iActive_Flag = 1 and EQS.tScheduled_time < {^2006-05-03 00:00:00} ;
>>>        and TEQ.iActive_flag = 1 ;
>>>        inner join Trans on Trans.cTrans_pk = TEQ.cTrans_fk ;
>>>        where Trans.cResolution_Codes_fk is Null
>>>

>>
>>
>>select cTrans_pk, cCommission_Owner_UsGrLink_fk as cUsGrlink_pk from FORCE Employee_Queue_Schedules EQS inner join Trans_Employees_Queues TEQ on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk AND EQS.iActive_Flag = 1 and EQS.tScheduled_time < {^2006-05-03 00:00:00} and TEQ.iActive_flag = 1 inner join Trans on Trans.cTrans_pk = TEQ.cTrans_fk where Trans.cResolution_Codes_fk is Null into cursor curTest
>>Using index tag Tschedtime to rushmore optimize table eqs
>>Rushmore optimization level for table eqs: partial
>>Rushmore optimization level for table teq: none
>>Joining table eqs and table teq using index tag Cempque_pk
>>Rushmore optimization level for intermediate result: none
>>Using index tag Crescod_fk to rushmore optimize table trans
>>Rushmore optimization level for table trans: full
>>Joining intermediate result and table trans using index tag Ctrans_pk
>>
>>Also takes 3 seconds.
>>
>>I was testing with my local tables.
>
>were they 34 s before?
>Have you a result with remote tables ?

27 seconds for both cases on network database. There are no users of it currently.