>>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?
>
>Sorry but I don't have your tables, no idea about structures, indexes, SQL that gets executed etc.
>Cetin

SQL is written right above the optimization plan info. Trans table has an index on cResolution_Codes_fk and primary index on cTrans_fk,

TEQ table has indexes on primary key, fk and a newly added binary index on iActive_Flag = 1

EQS table has indexes on PK, FK, tSchedule_Date and newly added binary index on iActive_Flag = 1

What strange is that these two new indexes are not listed in the optimization plan.