>>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... :(
If it's not broken, fix it until it is.
My Blog