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