>>I DID IT!!!!!!! ????
>>
>>

>>TEXT TO lcSQLStr NOSHOW TEXTMERGE PRETEXT 7
>>    SELECT Trans_Employees_Queues.cTrans_Employees_Queues_pk , ;
>>           Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk as cUsGrlink_pk ;
>>    FROM Trans_Employees_Queues ;
>>    INNER JOIN Employee_queue_schedules ;
>>    ON Trans_employees_queues.cTrans_employees_queues_pk = ;
>>     Employee_queue_schedules.cTrans_employees_queues_fk ;
>>     inner join Trans on Trans_Employees_Queues.cTrans_fk = Trans.cTrans_pk ;
>>     and Trans.cResolution_Codes_fk is NULL ;
>>    WHERE <<m.lcFilter>>
>>ENDTEXT

>>
>>In other words, changing the order of tables seems to give a great impact on performance. This query ran in 5 seconds.
>
>Congratulations! Of course, it looks like you simplified the query at the same time as you are no longer checking the status of iActiveFlag. Or are you doing that in lcFilter?
>
>Regards,

No, I was just testing and removing not important code for now. The problem is, that I don't see a performance improvement on my local machine and in order to test it for the network I have to wait for my colleague to cut a new executable... :(