SELECT COUNT(Trans.cTrans_pk) as iAccounts_Count, ; IIF(not IsNull(Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk), ; Trans_Employees_Queues.cCommission_Owner_Usgrlink_fk, ; Trans_Employees_Queues.cUsGrLink_fk) as cUsGrlink_pk, ; SUM(Trans.yCurrent_balance_amount) as yBalance ; FROM TRANS INNER JOIN Trans_employees_queues ; ON Trans.cTrans_pk = Trans_employees_queues.cTrans_fk ; INNER JOIN Employee_queue_schedules ; ON Trans_employees_queues.cTrans_employees_queues_pk = ; Employee_queue_schedules.cTrans_employees_queues_fk ; WHERE Trans.cResolution_Codes_fk is Null ; AND Employee_queue_schedules.tScheduled_time <= {^2006-05-02 23:59:59} ; AND Trans_employees_queues.iActive_Flag = 1 ; AND Employee_queue_schedules.iActive_Flag = 1 ; AND ; IIF(not IsNull(Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk), .T., ; (Trans_employees_queues.iTemporary_Assignment_Flag = 1 AND ; Trans_employees_queues.tStart_Date <= {^2006-05-02 23:59:59} AND ; Trans_employees_queues.tExpire_Date >= {^2006-05-02 23:59:59})) GROUP BY 2Using index tag Crescod_fk to rushmore optimize table trans