Also while you're at, do you know why I get

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 ;     
WHERE 	 Trans_Employees_Queues.iActive_Flag = 1 ;
	 AND Employee_queue_schedules.tScheduled_time <= {^2006-05-03 23:59:59} ;
    AND Employee_queue_schedules.iActive_Flag = 1 ;
    and Trans.cResolution_Codes_fk is NULL ;
	    

&tcSql
Rushmore optimization level for table trans_employees_queues: none
Using index tag Tschedtime to rushmore optimize table employee_queue_schedules
Rushmore optimization level for table employee_queue_schedules: partial
Using index tag Crescod_fk to rushmore optimize table trans
Rushmore optimization level for table trans: full
Joining table trans and table trans_employees_queues using index tag Ctrans_fk
Joining intermediate result and table employee_queue_schedules using index tag Cempque_fk

despite the fact I have binary indexes on iActive_Flag = 1 in both tables where I use this condition?